A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Retaining "FileName" field after merging document



 
 
Thread Tools Display Modes
  #1  
Old November 25th, 2008, 09:59 PM posted to microsoft.public.word.mailmerge.fields
Cheddarbug10
external usenet poster
 
Posts: 3
Default Retaining "FileName" field after merging document

In my primary document I have a "filename" field code in the footer. After I
complete the merge, the field code becomes static. Is there a way to keep
the field code in the footer?
  #2  
Old November 25th, 2008, 10:51 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Retaining "FileName" field after merging document

Well, sort of. You can
a. Put a { Filename } field into a blank document, bookmark it as fname and
save it as (say) c:\mydocs\fname.doc
b. In your mail merge main document use an

{ INCLUDETEXT "c:\\mydocs\fname.doc" fname }

c. Do the merge. The includetext survives. if you update the includetext
fields, you shoud see the file name of the container document.

The problem of course is that you are left with one or more links to an
external document. I'd probably unlink all the INCLUDETEXT fields a.s.a.p

To avoid that, I'd probably go for something more like
a. use a distinctive { PAGE } field such as
{ PAGE \#FILENAME }
b. merge
c. use Edit/Replace or a macro to display field codes and replace PAGE
\#FILENAME by FILENAME
d. update fields.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Cheddarbug10" wrote in message
...
In my primary document I have a "filename" field code in the footer.
After I
complete the merge, the field code becomes static. Is there a way to keep
the field code in the footer?


  #3  
Old November 25th, 2008, 11:34 PM posted to microsoft.public.word.mailmerge.fields
Cheddarbug10
external usenet poster
 
Posts: 3
Default Retaining "FileName" field after merging document

Thanks for replying.

Well, the first option is a bit cumbersome. The 2nd option I've tried. The
problem I'm having is that the "merged" document has many sections and the
Find/Replace was only finding text in the current section. Any clues as to
how I can make a find/replace in footers with many sections?

Stephanie~


"Peter Jamieson" wrote:

Well, sort of. You can
a. Put a { Filename } field into a blank document, bookmark it as fname and
save it as (say) c:\mydocs\fname.doc
b. In your mail merge main document use an

{ INCLUDETEXT "c:\\mydocs\fname.doc" fname }

c. Do the merge. The includetext survives. if you update the includetext
fields, you shoud see the file name of the container document.

The problem of course is that you are left with one or more links to an
external document. I'd probably unlink all the INCLUDETEXT fields a.s.a.p

To avoid that, I'd probably go for something more like
a. use a distinctive { PAGE } field such as
{ PAGE \#FILENAME }
b. merge
c. use Edit/Replace or a macro to display field codes and replace PAGE
\#FILENAME by FILENAME
d. update fields.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Cheddarbug10" wrote in message
...
In my primary document I have a "filename" field code in the footer.
After I
complete the merge, the field code becomes static. Is there a way to keep
the field code in the footer?



  #4  
Old November 26th, 2008, 10:21 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Retaining "FileName" field after merging document

I'd try a bit of VBA code as follows. See Graham Mayor's page for how to
install it:

http://www.gmayor.com/installing_macro.htm

I think this will do:

Sub UpdateAllFields()

Dim objRange As Word.Range
Dim objField As Word.Field
For Each objRange In ActiveDocument.StoryRanges
Call ProcessFields(objRange)
While Not (objRange.NextStoryRange Is Nothing)
Set objRange = objRange.NextStoryRange
For Each objField In objRange.Fields
Call ProcessFields(objRange)
Next
Wend
Next
Set objRange = Nothing
End Sub

Sub ProcessFields(objRange As Range)
Dim objField As Word.Field
For Each objField In objRange.Fields
' This has to be an exact match
If UCase(Trim(objField.Code.Text)) = "PAGE \#FILENAME" Then
objField.Code.Text = " FILENAME "
objField.Update
End If
Next
End Sub

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Cheddarbug10" wrote in message
...
Thanks for replying.

Well, the first option is a bit cumbersome. The 2nd option I've tried.
The
problem I'm having is that the "merged" document has many sections and the
Find/Replace was only finding text in the current section. Any clues as
to
how I can make a find/replace in footers with many sections?

Stephanie~


"Peter Jamieson" wrote:

Well, sort of. You can
a. Put a { Filename } field into a blank document, bookmark it as fname
and
save it as (say) c:\mydocs\fname.doc
b. In your mail merge main document use an

{ INCLUDETEXT "c:\\mydocs\fname.doc" fname }

c. Do the merge. The includetext survives. if you update the includetext
fields, you shoud see the file name of the container document.

The problem of course is that you are left with one or more links to an
external document. I'd probably unlink all the INCLUDETEXT fields a.s.a.p

To avoid that, I'd probably go for something more like
a. use a distinctive { PAGE } field such as
{ PAGE \#FILENAME }
b. merge
c. use Edit/Replace or a macro to display field codes and replace PAGE
\#FILENAME by FILENAME
d. update fields.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Cheddarbug10" wrote in message
...
In my primary document I have a "filename" field code in the footer.
After I
complete the merge, the field code becomes static. Is there a way to
keep
the field code in the footer?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.