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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merged letter and made changes to merged letters. Final merged doc
Merged letter and made changes to merged letters. Final merged document has
date in field code and atty wants to change it from Jan 5 to Jan 4. She does search and replace but the date automatically updates on print, even if we change that setting. -- Serena |
#2
|
|||
|
|||
Merged letter and made changes to merged letters. Final merged doc
-- Serena "Serena K." wrote: Merged letter and made changes to merged letters. Final merged document has date in field code and atty wants to change it from Jan 5 to Jan 4. She does search and replace but the date automatically updates on print, even if we change that setting. -- Serena |
#3
|
|||
|
|||
Merged letter and made changes to merged letters. Final merged doc
That's the thing about Date fields they update to the PC's system date.
You'll need to unlink them. The following macro will do that Sub Macro1() Dim oField As Field For Each oField In ActiveDocument.Fields If oField.Type = wdFieldDate Then oField.Unlink End If Next oField End Sub http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Serena K." wrote in message ... Merged letter and made changes to merged letters. Final merged document has date in field code and atty wants to change it from Jan 5 to Jan 4. She does search and replace but the date automatically updates on print, even if we change that setting. -- Serena |
#4
|
|||
|
|||
Merged letter and made changes to merged letters. Final merged doc
Hi Serena,
In your mailmerge main document, select the date field, press Ctrl-F9 to enclose it in a pair for field braces (eg { 01-05-2010}) and type 'QUOTE' inside the braces, so that you end up with {QUOTE 01-05-2010}. Then run your mailmerge. This will prevent the dates from updating in the future. It also means a Find/Replace on the dates will work. -- Cheers macropod [Microsoft MVP - Word] "Serena K." wrote in message ... Merged letter and made changes to merged letters. Final merged document has date in field code and atty wants to change it from Jan 5 to Jan 4. She does search and replace but the date automatically updates on print, even if we change that setting. -- Serena |
Thread Tools | |
Display Modes | |
|
|