How can you see what data file is connected to a main merge docum.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curious User - 21 Jan 2005 20:51 GMT

When you open an existing main merge document, how can you see what data file
is already attached to that document?

Reply to this Message

Doug Robbins - 21 Jan 2005 23:49 GMT

Run a macro containing the following command:

Msgbox Activedocument.MailMerge.DataSource.name

Or, from the Tools menu, select Customize and on the Commands tab of the
Customize dialog, select the All Commands category and locate the
MailMergeHelper command and left click, hold and drag it onto a toolbar or
menu. Then, with the mailmerge main document open, if you activate the
MailMergeHelper, the name of the data source will appear under the Data
source section of the Mail Merge Helper dialog.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> When you open an existing main merge document, how can you see what data
> file
> is already attached to that document?

Reply to this Message

Chris - 22 Mar 2005 20:36 GMT

> When you open an existing main merge document, how can you see what data file
> is already attached to that document?

If you can somehow open MS Query to analyze the data you'll see all the
data that is attached to that document.

I usually do this in Word 2000 by clicking on the Query Options button
on the Mail Merge Helper window.

Chris Weber

Reply to this Message