To get around the popup about a message being sent download the "Express
ClickYes" utility that is available as a free download from:
http://www.contextmagic.com/express-clickyes/
Express ClickYes is a tiny program that sits in the taskbar and clicks the
Yes button on behalf of you, when Outlook's Security Guard opens prompt
dialog saying that a program is trying to send an email with Outlook or
access its address book. You can suspend/resume it by double-clicking its
taskbar icon. Developers can automate its behaviour by sending special
messages.
As far as your HTML issue is concerned, I would never bother with it as you
really have no control over how the recipient reads their email.
Rather, I would send out the information as an attachment to an email (and
in .pdf format if I was really concerned about the appearance).
Get the addin for creating individual letters from a mailmerge in the
"Individual Merge Letters" item on fellow MVP Graham Mayor's website at:
http://www.gmayor.com/individual_merge_letters.htm
and to send each one out as an attachment to a mail merge,
See the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Dweezil38" wrote in message
...
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