Trouble creating a mail file for a party list in word?

Asked By SuzieGreen 0 points N/A Posted on - 09/20/2011

A friend of mine is having a very large gathering and I offered to create the mailing list for the invitations. I keep getting an error though whenever I attempt to merge the data from Excel into the Word documents.

I've never had this issue before. I tried restarting the computer as it had been running sluggish to begin with and ran disk defragment. Neither of these things solved my problem.

Here is the screen shot I get when I tried to merge the two files.

.

Microsoft Office Word

Word was unable to open the data source.

 

Any and all help will be greatly appreciated. Otherwise, I might just send it to the nice folks at Kinkos and they can fight with it.

Have a lovely day all.

• Status: Open
• Question Views: 854
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Mhelgamboa25 0 points N/A #126735

Trouble creating a mail file for a party list in word?

To work around the problem, start Word Mail Merge from the Word environment instead of the Access environment.

Here is the method. Hope this will help you.

1. Start Access 2000.
2. Open an Access database with the parameter query that you won't use.
3. In the database windows, click queries in the objects section, in the right pane, click the parameter query that you want to use, on the file menu, click export.
4. In the save as type combo box, click Microsoft Word Merge (*.txt), in the file name box, type a name for the Word Mail Merge file, and then click export.
5. In the enter parameter value dialog box, enter the required parameter value, and then click ok.
6. In a Word document, include this file as the data source for the recipients.

I'm sure that you will solve this problem with this.

God bless.

About Mhelgamboa25

Questions
0

Answers
13

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 09/21/2011
• Question Category: MS Excel