Excel datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mdthomann@gmail.com - 14 Nov 2005 17:54 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 14 Nov 2005 20:10 GMT

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

Signature

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

>I would like to add the path and filename of my datasource for an email
> merge. The merge itself works great.
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message