Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2000 and Email Merge in HTML Format
I always thought this was easy but evidently not!
Here's what I'm trying to do: I have an Access 2000 Database with a query that runs and gets Customer records based on a record showing on a Data Entry Form, eg: Get all records where Customer Category = Forms![MyDataEntryForm]![CustomerCategory] Now I want to create a Word 2000 Form Letter that will merge the data from the query results and email it out to each individual that has an Email address. (The Access Query only selects Customers that have a valid email address) The Email needs to be sent in HTML Format. I'm using Outlook Express 2000! Problems: I understand that my Access Database can not have a unique Application Title. I also know that when selecting the Data Source for the Word Form Letter that I should use "MS Access Database via ODBC (*.mdb)". This should set up the Word document to not open another copy of the Database but instead use the copy that is currently open. Is this right?? Should I use the "MS Access Database via DDE(*.mdb: *mde)"??? I have found that I get an error when I select the "Database via ODBC" and choose the query (View) that I want to use. The error says "Word unable to open data Source"? If I use "MS Access Database via DDE(*.mdb: *mde)" it will link and merge the data but when I go to the Merge Dialog box in Word, it does not indicate that I can specify HTML Format for the email. When I do click on the Merge button to initiate the merge and send each email letter, I get a message for each letter to be sent saying "A program is attempting to send the following email message on your behalf, with button to Send and another to Do not Send. How can I get around this message poping up for each email letter? Lastly, once I get to the point of having the email to go the Outbox in Outlook Express it is not in an HTML Format but instead in plain text???? Wordy question I know but.... how to I get an Access Query and Word to do an email mail merge and send out each letter in HTML Format without either program blowing up and having the user click on some dialog box message for each letter???? Thanks in advanced. Dweezil |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email Mail Merge to HTML format using Word 2007??? | Mailmerge | |||
How do I email and HTML format mail merge? | Mailmerge | |||
e-mail newsletter in word html but format is all wrong when email | Microsoft Word Help | |||
Email not sent in HTML format | Mailmerge | |||
EMail Merge HTML Format | Mailmerge |