Replace Sorce of data in MSWord merge document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichaelK - 30 Sep 2004 00:05 GMT

I'm opening merge a Word document from Access.

I can keep the same Query as a source of data for fields in the document
and just replace the body of the query.

Is there a way to change the Query name as the source of data for merging on
the fly from the Access? If so then how to do it in VBcode?

Thanks,
Michael.

Reply to this Message

david epsom dot com dot au - 30 Sep 2004 07:16 GMT

To change the body of a query:

application.querydefs("myquery").sql = "Select * from tbl"

You can also set the Word merge datasource before doing the merge.
You need to ask in a Word group to find how to do that.

(david)

> I'm opening merge a Word document from Access.
>
[quoted text clipped - 6 lines]
> Thanks,
> Michael.

Reply to this Message

MichaelK - 30 Sep 2004 17:29 GMT

Thanks David.
I know how to replace query sql.
May be I wasn't clear, I'm looking the way to replace datasource of the Word
document
on the fly while I'm in Access. Don't want to go in the word document and do
it manually.

Regards,
Michael

> To change the body of a query:
>
[quoted text clipped - 16 lines]
>> Thanks,
>> Michael.

Reply to this Message

John Nurick - 30 Sep 2004 20:47 GMT

Hi Michael,

I can't remember whether I've ever tried it, but AFAIK you need to
manipulate the Word document's MailMerge.DataSource object or
MailMerge.DataSource.Connect string.

>Thanks David.
>I know how to replace query sql.
[quoted text clipped - 26 lines]
>>> Thanks,
>>> Michael.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message