Sendind emails from within Access

[Guest]

I have an Access 2002 database which holds email addresses in text boxes. I
also have a number of Word Documents (outside the database). I wish to be
able to send a particular word document to a specific email address from
within Access without having to add the recipients details to Outlook
Express. Is this possible in Access 2002 and what VBA code can I use to do
it. From within Access I can determine the name and full patch of the Word
Documents I wish to send.

Help!

 

[michael_parry2005]

Hi

I don't know if this will help at all

Good luck

http://www.databasedev.co.uk/send_email.html

 

[Ron2006]

A work-around that may work until 2007 is out:

You might be thinking of the free Express ClickYes
http://www.express-soft.com/mailmate/clickyes.html (although there are
others as well)

Ron

 

[Tony Toews]

I have an Access 2002 database which holds email addresses in text boxes. I
also have a number of Word Documents (outside the database). I wish to be
able to send a particular word document to a specific email address from
within Access without having to add the recipients details to Outlook
Express. Is this possible in Access 2002 and what VBA code can I use to do
it. From within Access I can determine the name and full patch of the Word
Documents I wish to send.

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm