Re: Automate opening a merge with Mailmerge Recipients open

Tech-Archive recommends: Fix windows errors by optimizing your registry

> 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?
.

Relevant Pages

  • Re: Merging data from Access Query
    ... merged into a word document, I get the SQL message about merging data into ... I have re-established the links from the query to the table fields, ... the SQL information inside of word to make sure everything is right for the ... to merge the fields from the access database query, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: mailmerging multiple tables from access in one word-document: how?
    ... >A query would seem likely but there I have a problem. ... >knows 8 languages ... Sending the Current Record to Word with Automation ... Access a database and insert into a Word document the data that you find ...
    (microsoft.public.access.externaldata)
  • Waiting for MSAccess to execute DDE commands
    ... Excel and Access and the Word mail merge document just hangs. ... Can you convert the query to a make table query and then use that table as ... > When I open the Word document, Access opens and I get the login screen for ... > I have moved both the Access database and Word document to my local drive ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Mail merge to Word using 1:m relationship
    ... "Duane Hookom" wrote: ... Use this table joined to tbleJobs.JobTitle in a saved query. ... "scubadiver" wrote: ... I was pointed to the following to merge a current record to a Word document ...
    (microsoft.public.access.queries)
  • Re: Merging data from Access Query
    ... What is the Query's SQL? ... to merge the fields from the access database query, ... information that the query needs to pull back the record and merge it. ... the form is a merge button to merge fields into a word document. ...
    (microsoft.public.word.mailmerge.fields)