Reply
 
Thread Tools Display Modes
  #1   Report Post  
Raven
 
Posts: n/a
Default Saving a merge letter changes previous letters

I have Word 2003, as we just migrated to WinXP. I have a form letter with
merge fields as a template. When I try to use the mail merge wizard and edit
to add a new recipient and save the letter, it looks ok. If I then close the
letter after I've "saved as" and look at it again, the personalized info is
gone, and they all look like the first one I typed. The other secretary said
to edit the data source directly, but it's doing the same thing. What is
this doing? I don't have time to re-write letters again and again because it
won't save what I just bloody typed!
  #2   Report Post  
Charles Kenyon
 
Posts: n/a
Default

If you actually merge the letter to a document, it will save what you typed.
You are doing what I do, merging to a screen preview which can be printed.
This still has live fields.

What I've done is add two buttons to my merge toolbar to lock and unlock
fields. These trigger the following two macros:

Sub FieldsLockAllStory()
' All Story Field Locker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = True
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub
Sub FieldsUnLockAllStory()
' All Story Field Unlocker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = False
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub

I use a modified version of the padlock button from the forms toolbar for
these (changed color on both and open lock on the one to unlock).

Note if you have a Page X of Y in your header/footer, you'll want to
manually unlock that field or it will be wrong.

Otherwise, you can print as a pdf file.

--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Raven" wrote in message
...
I have Word 2003, as we just migrated to WinXP. I have a form letter with
merge fields as a template. When I try to use the mail merge wizard and
edit
to add a new recipient and save the letter, it looks ok. If I then close
the
letter after I've "saved as" and look at it again, the personalized info
is
gone, and they all look like the first one I typed. The other secretary
said
to edit the data source directly, but it's doing the same thing. What is
this doing? I don't have time to re-write letters again and again because
it
won't save what I just bloody typed!



  #3   Report Post  
Raven
 
Posts: n/a
Default

How would I be able to tell? and why would it change the letter *after* I
saved it? I also have no idea what you're talking about with unlocking and
writing macros.
Meg

"Charles Kenyon" wrote:

If you actually merge the letter to a document, it will save what you typed.
You are doing what I do, merging to a screen preview which can be printed.
This still has live fields.

What I've done is add two buttons to my merge toolbar to lock and unlock
fields. These trigger the following two macros:

Sub FieldsLockAllStory()
' All Story Field Locker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = True
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub
Sub FieldsUnLockAllStory()
' All Story Field Unlocker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = False
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub

I use a modified version of the padlock button from the forms toolbar for
these (changed color on both and open lock on the one to unlock).

Note if you have a Page X of Y in your header/footer, you'll want to
manually unlock that field or it will be wrong.

Otherwise, you can print as a pdf file.

--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Raven" wrote in message
...
I have Word 2003, as we just migrated to WinXP. I have a form letter with
merge fields as a template. When I try to use the mail merge wizard and
edit
to add a new recipient and save the letter, it looks ok. If I then close
the
letter after I've "saved as" and look at it again, the personalized info
is
gone, and they all look like the first one I typed. The other secretary
said
to edit the data source directly, but it's doing the same thing. What is
this doing? I don't have time to re-write letters again and again because
it
won't save what I just bloody typed!




  #4   Report Post  
Charles Kenyon
 
Posts: n/a
Default

A merge is made up of a primary merge document with fixed text and merge
fields combined with a data source. Each record in the data source will put
different things in the fields. Word knows or remembers that you are working
with the 17th record, which happens to be James Smith. You save it. You
change your data source by adding or deleting records and now the 17th
record is Mary Parsons. When you reopen your letter with unlocked fields, it
will fill in the blanks with information about Mary Parsons.

If you select your entire document (Ctrl-A) and lock the fields in it
(Ctrl-3) before saving it, they won't change when you reopen it later. A
macro makes it easier if you are going to be doing it a lot or if you have
fields in headers or footers.

Otherwise, if you simply actually perform a merge to a document, that result
would also be fixed.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Raven" wrote in message
...
How would I be able to tell? and why would it change the letter *after* I
saved it? I also have no idea what you're talking about with unlocking
and
writing macros.
Meg

"Charles Kenyon" wrote:

If you actually merge the letter to a document, it will save what you
typed.
You are doing what I do, merging to a screen preview which can be
printed.
This still has live fields.

What I've done is add two buttons to my merge toolbar to lock and unlock
fields. These trigger the following two macros:

Sub FieldsLockAllStory()
' All Story Field Locker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = True
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub
Sub FieldsUnLockAllStory()
' All Story Field Unlocker
' Written by Charles Kyle Kenyon 9 December 2004
' repaired with help from Jezebel 10 December 2004
Dim oStory As Range
On Error Resume Next
For Each oStory In ActiveDocument.StoryRanges
Do
oStory.Fields.Locked = False
Set oStory = oStory.Next
Loop Until oStory Is Nothing
Next
End Sub

I use a modified version of the padlock button from the forms toolbar for
these (changed color on both and open lock on the one to unlock).

Note if you have a Page X of Y in your header/footer, you'll want to
manually unlock that field or it will be wrong.

Otherwise, you can print as a pdf file.

--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Raven" wrote in message
...
I have Word 2003, as we just migrated to WinXP. I have a form letter
with
merge fields as a template. When I try to use the mail merge wizard
and
edit
to add a new recipient and save the letter, it looks ok. If I then
close
the
letter after I've "saved as" and look at it again, the personalized
info
is
gone, and they all look like the first one I typed. The other
secretary
said
to edit the data source directly, but it's doing the same thing. What
is
this doing? I don't have time to re-write letters again and again
because
it
won't save what I just bloody typed!






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
Mail Merge is creating blank pages between form letters JW Mailmerge 1 January 25th 05 10:54 PM
How can I after a mail merge save each letter individually in a d. Rebecca Mailmerge 2 January 20th 05 04:05 PM
capitalization of the first letter in a mail merge field + excepti karel Mailmerge 1 January 4th 05 10:11 AM
Saving form letters individually John Calligy Mailmerge 1 December 17th 04 10:03 AM
Previous version of Mail Merge style d2power Microsoft Word Help 1 December 15th 04 12:56 AM


All times are GMT +1. The time now is 07:21 PM.

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"