Access and Outlook - automatically generate emails if I track addresses in Access

  • Thread starter Thread starter BP
  • Start date Start date
B

BP

Hi there,
I'm using Access 2000. In a "person" table, I have a field for email
address. Is there a way to create a query or something that would allow me
to easily use those email addresses for communication via Outlook? In a
nutshell, I don't want to recreate all of the email addresses in Outlook.
Can I use the email addresses saved in my Access table to easily generate an
Outlook email???

I hope this makes sense. Your help is greatly appreciated!!
 
BP said:
Hi there,
I'm using Access 2000. In a "person" table, I have a field for email
address. Is there a way to create a query or something that would allow me
to easily use those email addresses for communication via Outlook? In a
nutshell, I don't want to recreate all of the email addresses in Outlook.
Can I use the email addresses saved in my Access table to easily generate an
Outlook email???

I hope this makes sense. Your help is greatly appreciated!!
Click to expand...
Yes, go into modules, open an existing module or create a new one. Open
Tools -> References, then select the library for Outlook. Press F2 and
you'll see the events and methods.
This is not exactly a gettingstarted topic though.
Marc
 
Thank you for your reply and your time. Yes, I agree that this wasn't the
most appropriate newsgroup for this post. However, the appropriate group
was not obvious to me. Perhaps you could direct me to the right group
should I require more help.
 
BP said:
Thank you for your reply and your time. Yes, I agree that this wasn't the
most appropriate newsgroup for this post. However, the appropriate group
was not obvious to me. Perhaps you could direct me to the right group
should I require more help.
Click to expand...
microsoft.public.outlook.* - there are several there - maybe.
Have you managed to get an email sent using the libraries?

http://www.microsoft.com/outlookdev/articles/movs105.htm - this is a bit out
of date, but seems to be a good overview of what you need.
HTH
Marc
 
BP, you can use email addresses stored in Access to drive an Outlook mail
merge, but there are two catches: (1) the addresses must be stored as text,
not as hyperlinks; (2) you have to go through Word to get to Outlook.

If your addresses are stored as text, just select the table that holds them,
pull down the Tools menu, select Office Links, then select Merge It with
Word. Make your way through the wizard, which is fairly intuitive, and merge
to electronic mail. I think you'll find it's a fairly easy process once
you've done it.

DDM
"DDM's Microsoft Office Tips and Tricks"
http://ddmara.tripod.com
 
Back
Top