Can I send messages from access using outlook?

B

Brian

I thought it was possible to link the address book in Outlook to my Access
data base. I'm unsure what to do.
 
T

Tom Wickerath

Hi Brian,

Yes, you can send messages from Access using Outlook (or any SMTP compliant
e-mail program, for that matter). The easiest method involves using
SendObject. For a more complete method, see page 17 of my Access Links.doc
Word document, which you can download here:

http://home.comcast.net/~tutorme2/samples/accesslinks.zip

Here is another method, courtesy of Access MVP Arvin Meyer:

http://www.datastrat.com/DataStrat2.html (see EmailSenate)

As for getting e-mail addresses from your Outlook Contacts....well, that's a
bit more difficult. You see, that's exactly what the virus writers started
doing several years ago, so Microsoft was forced to block access to this
data. You can export your Contacts data to a comma delimited text file, and
then import this into a table in Access, but the data will represent a
snapshot in time only. Probably better to just set up a table link in Access,
and link to the text file directly. That way, you can easily update the
information available to your program by just going through the process to
export your contact info. to the text file again, replacing the original copy.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Top