troubleshooting Question

Locating Mail Merge Input

Avatar of mlcktmguy
mlcktmguyFlag for United States of America asked on
Microsoft Word
3 Comments1 Solution60 ViewsLast Modified:
Locating Mail Merge Input
I have been a developer for decades but I am very new to working with Mail Merge documents.

A client asked to have some of their mail merge documents generated directly from the application I am writing for them.
The client sent me a Word, mail merge document and the associated data file.  I put both in a directory on my computer.  The input file is named ‘TCLMDATA.DAT’.

When I try to open the Mail Merge doc I get a message “Opening this document will run the following SQL command”, “ Select * from U:\TCLMDATE”, “Do you want to Continue?.

When I select ‘Continue”, I get a message “Word cannot find the data source U:\TCLMDATA”.  This makes sense because I have the file in a different location than “U:\”.

When I select the option to “Find Data Source”, I locate the supplied file on my computer and select it.  But then Word puts up the message “Word cannot find its data source, “ then shows the name and location of the file I selected.

I know the file exists.  I didn’t type the name I just selected it in the file finder.  Why am I getting the message that the file wasn’t found and how do I resolve this?

I suspected that the file having a ‘.DAT” extension was the problem so I created another version of the file with a .txt” extension.  I ended up with the same messages and result.
ASKER CERTIFIED SOLUTION
GrahamSkan
Retired
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros