View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Karen Townsend
 
Posts: n/a
Default Word 2003 Mail Merge Problem when E-Mailing Data Source

The data source is a.mdb file for a Word document. When it is e-mailed, I
right click and save the document in my Word files and the data source in My
Data Sources. They are both being sent in the same e-mail as attachments.
Files are then saved on the recipients hard drive or on a corporate shared
drive. We have tried both ways and get the same results.

When the files come across in the e-mail attachment, the Word file is fine;
however, the .mdb file comes across as "warning.htm" as the file name. If
you try to open it, you get a message indicating "Blocked File Alert." We
thought that might be a network issue on our end, so I sent it to my home
e-mail address and get the same thing. I've tried saving it as an .mdb file
with the origina name and move to the next steps indicated below.

After the files are saved, I open the Word file and am told that "....file
name... is a mail merge document. Word cannot find its data source." I
choose the option to "find data source" and am directed to a "Data Link
Properties" box where I am asked to "Specify the following to connect to
Access data. Select or enter a database name." When I choose the database
name, I get another box "ODBC Microsoft Access Driver Login Failed;
Unrecognized database format."

"Peter Jamieson" wrote:

What is the data source (a Word document? a .mdb file? something else?)

Are you e-mailing the mail merge main document and the data source in the
same e-mail? As attachments? If so, are the recipients extracting and saving
the mail merge main document and data source in the same way? Where are they
putting the files?

What warnings are the recipients seeing? If one of them is to do with
execution of a SQL command then they may need to apply the information in
the following article

"You receive the "Opening this will run the following SQL command" message
when you open a Word mail merge main document that is linked to a data
source"

http://support.microsoft.com/kb/825765

I don't like the additional complication either...

Peter Jamieson

"Karen Townsend" Karen wrote in message
...
I can't believe Microsoft would make Word 2003 so non-user friendly when it
comes to their "improvements" to the Mail Merge process. We finally
figured
out how to use and edit fields, but the major problem we are having is in
e-mailing the mail merge document and its data source. The document and
the
data source work just fine if you have created it on your pc, but if you
try
and e-mail it to another user, you get warnings and the data source will
not
properly open. You have to search for the data source each and every time
you open the document. Anyone have any suggestions?