Property: path to mail merge source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monika Krug - 11 Nov 2004 14:00 GMT

Is there a Word document property or something like that
which stores the path to the current mail merge source (if
there is one)?

Where could I search to find out such an information? I
tried Word help, but if this information is in there at
all, I did not use the right search terms.

TIA,
Monika.

Reply to this Message

Doug Robbins - 12 Nov 2004 00:27 GMT

Use a macro containing the following command

If ActiveDocument.MailMerge.DataSource.Name <> "" Then
MsgBox ActiveDocument.MailMerge.DataSource.Name
Else
MsgBox "No data source attached to the active document."
End If

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

> Is there a Word document property or something like that
> which stores the path to the current mail merge source (if
[quoted text clipped - 6 lines]
> TIA,
> Monika.

Reply to this Message

Monika Krug - 12 Nov 2004 09:54 GMT

Thank you, both of you!

Monika.

Reply to this Message

Peter Jamieson - 12 Nov 2004 00:38 GMT

For file data sources,

ActiveDocument.MailMerge.DataSource.Name

is probably the property you need. If for example you are accessing an SQL
Server database, where the ConnectString property may be more useful, and
the file property may in some cases point to a .odc which just contains some
information about the data source.

In Word 2002 you may have difficulty getting the values of some of these
properties as accessing them may cause Word to crash.

Peter Jamieson

> Is there a Word document property or something like that
> which stores the path to the current mail merge source (if
[quoted text clipped - 6 lines]
> TIA,
> Monika.

Reply to this Message

Cindy M -WordMVP- - 12 Nov 2004 12:15 GMT

Hi Monika,

> Is there a Word document property or something like that
> which stores the path to the current mail merge source (if
> there is one)?
>
> Where could I search to find out such an information?

With Word 2002/2003, the quickest way is to go over
Help/"About"/System Info, then drill down to the mail merge
information for Word.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply to this Message