Need Help Please! Pull Data from Access 2003 into Outlook 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I pull data from an Access 2003 DB into a preformatted MS Outlook 2003
email? I have record sets in a DB that contains data that needs to be send
to people.

-----------------------------------------------------------------------------------------
Example DB:
<account_name> <name> <email> <room_num> <last_used
-----------------------------------------------------------------------------------------
Example Email:
FROM: ADMIN
TO: <email>
SUBJ: Subject Goes Here
Hello <name>,
Your <room_num> has not been used since <last_used> on account
<account_name>. This room will be perged if not used with in 30 days.

Thank you
-----------------------------------------------------------------------------------------

Also, accounts can contain several rooms, I have to only send ONE email to
each <email> and contain all the <room> data for those <account_name> 's into
one email. What's the best course of action for this? Use Access or
Outlook? How do I go about it?
 
There's a kazillion ways to do this! It all depends on where it is logical
to create these e-mails. If the users are working inside an Access
application where data actions or a business process requires sending an
e-mail, set a reference to the Microsoft Outlook X.0 Object Model in Access
and create the code to automate creating the e-mail and populate it with data
from your tables.

If the users work in Outlook all day, then you can write VBScriopt code
behind custom forms or write VBA macros that use ADO, DAO or the Access
Object Model to get the data from the database and populate the e-mails with
it.

See this link for more info:

Connecting Outlook and Exchange to Databases:
http://www.outlookcode.com/d/database.htm
 
In addition to what Eric said, if you can devise a way to concatenate the
information on the multiple rooms per account so that it appears in one
table or query, you can simply use a mail merge to Word.
 
Back
Top