In my database I have all the "information" I need to create an advertisement. Image paths, links, text, etc.

However, I am not having a lot of success in creating a good looking ad, and having this ad show in the body of an E-mail. After some reading, it seems that Access may not be my best solution for creating an advertisement anyway.

I have seen some information on creating an HTML template, but I have no idea where to even start on this.

So I guess what I am really looking for is:

1. How to create an HTML template that will read data from access
or
2. Some 3rd party software I can export in to that will create some good looking E-mails
or
Something else you can think of to accomplish the above.

Thank you!

Depends on how complex but one idea is to create the HTML then use Access to insert the data and send it.

So for example you create the Nice looking HTML but with placeholders where you want to put the data eg [Given_Name] and [Product_Info]

Then when you send the email just do a replace to fill in the specifics



I don't know how much detail you need on creating recordsets from your Customer table etc or

how much info you need on how to send an email from Access but that's how I'd get the data into the HTML

Kent,

Thank you!

This gives me a place to start.

Since you mentioned you are looking for third party products:
I have a new email template product with source code (releasing it perhaps tomorrow or the next day).

Example of an email template:
http://www.donationmanagementsoftware.com/...ate1/index.html

check
http://www.microsoftaccesstemplate.com/
In the next few days. When the website changes completely you will know the new product is out.

the email product is similar to the old email template product I have now except more geared for Access 2007 and above and lets you preview emails in Outlook and send via Outlook instead of using a third party smtp component.

you send a sql string to the function and it has all the tools to build email templates with merge fields and use them to send and preview emails.
You can send one email or a few hundred with little work.

It might help you instead of writing everything yourself?

Mark