Saving a copy of a mailmerge document with the fields fixed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gilbert De Ceulaer - 22 Dec 2006 00:05 GMT

I use a template with mailmerge fields (date, number, name, address,...)
Is there a way to save a copy of that document with the merged fields fixed
?

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
2791 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!

Reply to this Message

macropod - 22 Dec 2006 01:05 GMT

Hi Gilbert,

If you create a new document based on the template, then use Ctrl-A to select it all, followed by Ctrl-Shift-F9 to convert the
fields to text, that will 'fix' the mergefields.

Cheers

Signature

macropod
[MVP - Microsoft Word]

| I use a template with mailmerge fields (date, number, name, address,...)
| Is there a way to save a copy of that document with the merged fields fixed
[quoted text clipped - 4 lines]
| 2791 spam-mails zijn er tot op heden geblokkeerd.
| Download de gratis SPAMfighter vandaag nog!

Reply to this Message

Bruce - 22 Dec 2006 01:07 GMT

I had the SAME question last week!
Graham Mayor responded with :

Break the link with Excel - CTRL+A then CTRL+SHIFT+F9
or by macro

Sub BreakLink()
Selection.WholeStory
Selection.Fields.Unlink
End Sub

You could incorporate this in the file save routine in your invoice template

Sub FileSave()
Selection.WholeStory
Selection.Fields.Unlink
ActiveDocument.Save
End Sub

Good luck!
Bruce

>I use a template with mailmerge fields (date, number, name, address,...)
> Is there a way to save a copy of that document with the merged fields
[quoted text clipped - 4 lines]
> 2791 spam-mails zijn er tot op heden geblokkeerd.
> Download de gratis SPAMfighter vandaag nog!

Reply to this Message