I'm having trouble getting things posted properly. My issue has
actually been
posted twice.
A lot of people seem to have been experiencing difficulties with the
web-based interface. But please bear in mind that you are not talking to
Microsoft here - most of the people who answer questions are volunteers.
How are you trying to modify the query before opening the Word document?
Are you using e.g. an Access data source and actually modifying the
Access query code, for example? Or are you actually setting Word's
Mailmerge.Datasource.Querystring property?
What you may find is tht you actually have no option but to disconnect
the existing data source and use MailMerge.OpenDatasource to open it
again, with the query you need.
Peter Jamieson
http://tips.pjmsn.me.uk
Graywolf wrote:
I'm having trouble getting things posted properly. My issue has actually been
posted twice. Please see and respond to my post for "Automate opening a merge
with Mailmerge Recipients open". And I'm using Word 2003 SP3, NOT Word 97.
"Graywolf" wrote:
I'm trying to automate a Word Mailmerge using VB6. I have an interface built
that allows the user to pick the type of document and I have basic
datasources defined for each document. In this specific example I'm doing a
merge for mailing labels. However, the end user needs to further refine who
gets a mailing label and who doesn't. I have built into the interface the
ability to pick and choose from the original query list the people who should
get a label. I can then change the underlying query before opening the Word
document. However, I can't seem to get the Word document to behave properly
and display my narrowed down list of recipients. All I can get to come up is
the full list (as if I never changed the underlying query). It appears that
if I alter the datasource in any way, then the merge breaks. So now what I
would like to do is just bring up the merge document with the full list of
recipients and have the "Merge Recipients" window open so the end user can
refine their list from Word instead of from my interface. How do I get the
merge to open with the "Merge Recipients" window opened up?