Generate Email Using field in Access Database

[Timothy Bates]

Is there a way using Access or Outlook (2003) to create a
email based on an address stored in Access. I have a
database with stored email addresses and events
(birthdays, anniversaries) and I would like to send
emails based on those dates.

 

[Cheryl Fischer]

There is code at the following link (watch out for wrapping) which will show
you how to use Access to create an Outlook appointment, create and send
emails and work with contacts.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/h
tml/office071299.asp

 

[Nurten Sahinsen]

test

There is code at the following link (watch out for wrapping) which will show
you how to use Access to create an Outlook appointment, create and send
emails and work with contacts.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/h
tml/office071299.asp

 

[Tony Toews]

Is there a way using Access or Outlook (2003) to create a
email based on an address stored in Access. I have a
database with stored email addresses and events
(birthdays, anniversaries) and I would like to send
emails based on those dates.

Using VBA code, with a query which looks at the tickler date based on
todays date. I.e. <= Date(), set a flag in those records as "about
to send emails", loop through the recordset to send the emails, update
the flag as "sent emails", and a sent date. Repeat tomorrow.

Also see the Access Email FAQ at my website.

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