Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Adding Data Source File Name to Word 2007 Merge
I am trying to add the file name for my data source to the bottom of my Word
2007 merge document & cannot find information on how to include. Any suggestions? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Adding Data Source File Name to Word 2007 Merge
You would need to run a macro containing the following code AFTER attaching
the data source to the mail merge main document: With ActiveDocument .Sections(1).Footers(wdHeaderFooterPrimary).Range. InsertAfter ..MailMerge.datasource.Name 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 "lee" wrote in message ... I am trying to add the file name for my data source to the bottom of my Word 2007 merge document & cannot find information on how to include. Any suggestions? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Adding Data Source File Name to Word 2007 Merge
Hi Lee,
An alternative approximation would be to use a DDE field to your main mailmerge document, coded along the lines of: {IF{MERGESEQ} 0 { dde excel system selection }} This will return the filename and the last field position from the file, in the form of: '[MailMergeData.xls]Sheet1'!R150C3 -- Cheers macropod [MVP - Microsoft Word] "lee" wrote in message ... I am trying to add the file name for my data source to the bottom of my Word 2007 merge document & cannot find information on how to include. Any suggestions? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2007 saving the data source | New Users | |||
Word 2007 data source file types | Mailmerge | |||
Mail Merge - How to create data source using Word 2007? | Mailmerge | |||
Word 2007 Mail Merge Data Source Read Only | Mailmerge | |||
word cannot open file as a data or header source bec it is a mail merge main doc | Mailmerge |