Excel datasource

[mdthomann]

I would like to add the path and filename of my datasource for an email
merge. The merge itself works great.

But to help me keep track of data, I would like to add the path and
filename of the datasource.

Similiar to FILENAME \p but for datasource.

Thanks

 

[Doug Robbins - Word MVP]

Use the following macro to insert the datasource with it's path at the
location of the selection:

With ActiveDocument
If .MailMerge.State = wdMainAndDataSource Then
Selection.InsertBefore .MailMerge.DataSource.Name
End If
End With


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP