By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,788 Members | 1,700 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,788 IT Pros & Developers. It's quick & easy.

VBA - Create Outlook email in html format based on template (word/outlook)

P: 1
I have MS Access Database clients database. When client places an order – I have developed VBA code to create an email confirming the details of the order.

Everything is coded, but the body text is concatenation of multiple notepad files and fields from the database.

I need to improve the code to be able to send html format email based on a template – it can be Word Template, or Outlook Template… something like Mail Merge in Word, but there will some details taken from the database to be populated on the email. Details like:

Clients name, address, order number, schedule date, type of order, estimated price, etc.
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply

P: 167
Have you tried using?
Expand|Select|Wrap|Line Numbers
  1. DoCmd.SendObject...
Here you can use templates for sending e-mails.
Read more in vba help about it....
Sep 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.