View Single Post
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default Excel datasource

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

wrote in message
oups.com...
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