emailing from field

  • Thread starter Thread starter TammyC
  • Start date Start date
T

TammyC

I'm currently using Windows 2000 w/Office 97, using
Outlook for email program. We have a vendor contact
database set up in Access with a field for email
addresses. I would like to be able to either click the
address or a command button associated w/email address and
open a "New Mail Message" in Outlook w/the email address
prefilled into the "To" field. I've searched help files
and MS site and have finally lost my mind completely with
the effort.

Please tell me there is a way to do this - by the way, I
fall into the "just past beginner" category in terms of
experience w/Access, but very savvy with programs and can
usually follow a good set of instructions...
 
Add a button to your form. In the 'onclick' property of the button select
'event procedure'. Click the elipse (...) to the right and the vba window
will open. Make your code look similar to the following...

Private Sub SendEmail_Click()
DoCmd.SendObject , , , [EmailAddressField]
End Sub

Rick
 
Note: You could place the same code in the onclick event for your email
field. This would save you from having to add a button, but it might not be
as obvious to users.

Rick
 
The following can be found, in Outlook - Help by typing
the following in the search criteria: "Import Distribution
list from Access". This will allow you to access the
category "Import a contact list or a file from another
Office program". Results:

On the File menu, click Import and Export
Click Import from another program or file
Follow the instructions in the Import and Export Wizard
 
This is part of the field or button properties when you are in design view
for the form.

Right click on the field in design view and select properties. Then, click
the 'event' tab.



Susanna said:
Where is the 'onclick' field? I assume in the table design view, but I
Click to expand...
don't see it there... do I just have the wrong version of Access? (Access
2000)
 
Back
Top