Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel datasource
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress prompts when merging from excel datasource | Mailmerge | |||
Problem with repeated access to the datasource (Excel Spreadsheet) | Mailmerge | |||
Formatting using Excel datasource for mail merge | Mailmerge | |||
mailmerge - excel datasource - other file extension? | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout |