Reply
 
Thread Tools Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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   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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress prompts when merging from excel datasource Dorothy Mailmerge 2 July 22nd 05 12:46 PM
Problem with repeated access to the datasource (Excel Spreadsheet) Mike C. Mailmerge 6 July 20th 05 11:01 AM
Formatting using Excel datasource for mail merge Shawna Mailmerge 1 February 26th 05 12:19 AM
mailmerge - excel datasource - other file extension? Ralf Pickel Mailmerge 1 February 14th 05 08:05 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM


All times are GMT +1. The time now is 02:08 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"