[Walter Briscoe]

I am using Word 2003 (11.6359.6360) SP1.
I have { ASK foo "bar" \o ) and { REF foo \* MERGEFORMAT } fields. *
Without "\o", I am prompted for each merged recipient when I do Edit
individual letters...\Merge to New Document\OK
When I add \o I am not prompted - EVER!
I want to be prompted once for a set of recipients.
I want to be prompted again when the set of recipients changes to a new
set.

* Word added "\* MERGEFORMAT" to my REF field. I assume it is a good
thing. Removing it does nothing to alter perceived behavior.
--
Walter Briscoe

[Graham Mayor]

Add an autoopen macro to the merge document template containing the line
ActiveDocument.Fields.Update
which will update the Ask field when you open the merge document and any
related REF fields that are in the main body of the document (REF fields in
headers etc may need updating separately)
http://www.gmayor.com/installing_macro.htm
If the document template was normal.dot this macro may be undesirable there,
so save the merge document as a template and attach it to your merge
document.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Walter Briscoe wrote:
I am using Word 2003 (11.6359.6360) SP1.
I have { ASK foo "bar" \o ) and { REF foo \* MERGEFORMAT } fields. *
Without "\o", I am prompted for each merged recipient when I do Edit
individual letters...\Merge to New Document\OK
When I add \o I am not prompted - EVER!
I want to be prompted once for a set of recipients.
I want to be prompted again when the set of recipients changes to a
new set.

* Word added "\* MERGEFORMAT" to my REF field. I assume it is a good
thing. Removing it does nothing to alter perceived behavior.

[Walter Briscoe]

I top-post my belated reply to conform with custom in this newsgroup.
Putting the last message after the sig is new to me and I hope it works.

It took me a long time to make sense of your valuable reply. I did not
see "Idiots' Guide to Installing Macros" at the bottom of the view
rendered on opening http://www.gmayor.com/installing_macro.htm

AutoOpen runs automatically on opening my main document and when it
opens the output document created when I click Edit individual
letters... (I infer this - I have yet to work out how to insert a
breakpoint in the code of a VBA module. I used to do this in C but am
unable to remember the technique. I have some memory of 3 as a function
parameter.) I use Edit... because Print... does not successfully produce
double-sided output on my printer.

I suppose I need a condition on ActiveDocument.Fields.Update which would
suppress it on the latter document. I have yet to find that condition
and hope for further assistance.

I got a copy of "Office VBA: Macros You Can Use Today" and applied Cindy
Meister's "Mail Merge: Using a Relative Path for Data Source" procedure.
(I now use the complicated version which opens Sheet1 automatically.)
I added the line
ActiveDocument.MailMerge.ShowWizard 5 'Open "Preview your Letters" pane
I have yet to find out how to automate "Edit recipient list..."

When I use that control, the order of columns in the window which opens
is not the same as in my data source. (The first data column is
"Postcode"; it is column J of my Excel data source.) I see the same
behavior (sic) with both the default and Cindy's version of "Use an
existing list". I hope this is an FAQ and would value a pointer to it.

I am sorry this is a portmanteau response. I am trying to run when
barely able to toddle.
--
Walter Briscoe
In message of Sun, 17 Feb 2008 10:34:58
in microsoft.public.word.mailmerge.fields, Graham Mayor
writes
Add an autoopen macro to the merge document template containing the line
ActiveDocument.Fields.Update
which will update the Ask field when you open the merge document and any
related REF fields that are in the main body of the document (REF fields in
headers etc may need updating separately)
http://www.gmayor.com/installing_macro.htm
If the document template was normal.dot this macro may be undesirable there,
so save the merge document as a template and attach it to your merge
document.

[Walter Briscoe]

In message of Sat, 1 Mar 2008
07:28:49 in microsoft.public.word.mailmerge.fields, Walter Briscoe
writes

Sorry to add something to last posting, but I found some things out.

I top-post my belated reply to conform with custom in this newsgroup.
Putting the last message after the sig is new to me and I hope it works.

It took me a long time to make sense of your valuable reply. I did not
see "Idiots' Guide to Installing Macros" at the bottom of the view
rendered on opening http://www.gmayor.com/installing_macro.htm

AutoOpen runs automatically on opening my main document and when it
opens the output document created when I click Edit individual
letters... (I infer this - I have yet to work out how to insert a
breakpoint in the code of a VBA module. I used to do this in C but am
unable to remember the technique. I have some memory of 3 as a function
parameter.) I use Edit... because Print... does not successfully
produce double-sided output on my printer.

My inference above is wrong.
A stop statement showed AutoOpen is not run for the output document.
I found no method to invert ActiveDocument.Fields.Update.


I suppose I need a condition on ActiveDocument.Fields.Update which
would suppress it on the latter document. I have yet to find that
condition and hope for further assistance.

I got a copy of "Office VBA: Macros You Can Use Today" and applied
Cindy Meister's "Mail Merge: Using a Relative Path for Data Source"
procedure.
(I now use the complicated version which opens Sheet1 automatically.)
I added the line
ActiveDocument.MailMerge.ShowWizard 5 'Open "Preview your Letters" pane
I have yet to find out how to automate "Edit recipient list..."

When I use that control, the order of columns in the window which opens
is not the same as in my data source. (The first data column is
"Postcode"; it is column J of my Excel data source.) I see the same
behavior (sic) with both the default and Cindy's version of "Use an
existing list". I hope this is an FAQ and would value a pointer to it.

I am sorry this is a portmanteau response. I am trying to run when
barely able to toddle.

--
Walter Briscoe

[Graham Mayor]

I have lost track of this thread, but if you want to run a macro on a *new*
document automatically you need to call it autonew rather than autoopen.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Walter Briscoe wrote:
In message of Sat, 1 Mar 2008
07:28:49 in microsoft.public.word.mailmerge.fields, Walter Briscoe
writes

Sorry to add something to last posting, but I found some things out.

I top-post my belated reply to conform with custom in this newsgroup.
Putting the last message after the sig is new to me and I hope it
works. It took me a long time to make sense of your valuable reply. I did
not see "Idiots' Guide to Installing Macros" at the bottom of the
view rendered on opening http://www.gmayor.com/installing_macro.htm

AutoOpen runs automatically on opening my main document and when it
opens the output document created when I click Edit individual
letters... (I infer this - I have yet to work out how to insert a
breakpoint in the code of a VBA module. I used to do this in C but am
unable to remember the technique. I have some memory of 3 as a
function parameter.) I use Edit... because Print... does not
successfully produce double-sided output on my printer.

My inference above is wrong.
A stop statement showed AutoOpen is not run for the output document.
I found no method to invert ActiveDocument.Fields.Update.


I suppose I need a condition on ActiveDocument.Fields.Update which
would suppress it on the latter document. I have yet to find that
condition and hope for further assistance.

I got a copy of "Office VBA: Macros You Can Use Today" and applied
Cindy Meister's "Mail Merge: Using a Relative Path for Data Source"
procedure.
(I now use the complicated version which opens Sheet1 automatically.)
I added the line
ActiveDocument.MailMerge.ShowWizard 5 'Open "Preview your Letters"
pane I have yet to find out how to automate "Edit recipient list..."

When I use that control, the order of columns in the window which
opens is not the same as in my data source. (The first data column is
"Postcode"; it is column J of my Excel data source.) I see the same
behavior (sic) with both the default and Cindy's version of "Use an
existing list". I hope this is an FAQ and would value a pointer to
it. I am sorry this is a portmanteau response. I am trying to run when
barely able to toddle.

[Walter Briscoe]

Thank you. I now have something which seems to work well.
I will manage without answers to my other questions.
--
Walter Briscoe

In message of Sat, 1 Mar 2008 11:44:48
in microsoft.public.word.mailmerge.fields, Graham Mayor
writes

I have lost track of this thread, but if you want to run a macro on a *new*
document automatically you need to call it autonew rather than autoopen.