Automate sending of "standard" email, with merged data

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

Guest

Here's what I need to do:

I have an Access application. When a user enters a new order to the
database, they want to be able to choose to send a "welcome" email by
clicking a button. This needs to be a "standard" email, BUT it needs to also
contain a "due date" by which the customer must reply, and which will vary
from order to order. This all needs to happen automatically when the user
clicks the appropriate button.

So, can I automate Outlook to open a "standard" message, to fill in the due
date, and send it to a specified recipient? The "standard" message needs to
contain logos and so forth, and be user-maintainable, because they will
change it occasionally.

Technical difficulty is not an issue - I'm perfectly comfortable with VBA
and with automation in general, I just don't know my way around Outlook.

For the sake of clarity, I should stress that this is not "bulk" email.
Each email is sent to just one customer at specific user request.

Thanks!

Baz
 
You can do all that but the due date will be just another piece of text in
the email body. You could add a flag and an expiration date to make the item
turn red when the due date passes and be flagged to make it easier to
notice.

See www.outlookcode.com for lots of Outlook code samples for creating and
populating emails using code.
 
If you scroll back through the messages a bit to a topic I started entitled
"Code Runs Right Every Second Time", then look at my message of Oct. 16,
2005 in that thread, you will see some sample code that opens Outlook and
populates a new e-mail message from several different Access data fields
from a button on the Access form. Hope that helps.

The code requires you to install Outlook Redemption
(http://www.dimastr.com/redemption/) to circumvent the Outlook Security
Patch.
 
Back
Top