Extracting Data from Mergefields with VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lwillis1 - 18 Sep 2004 19:29 GMT

I need to automatically print specific pages of a 4 page mail merg
document based on the content of a couple of mergefields.

I have an autoopen macro that is performing the merge upon opening th
document, but I do not know how to determine the value of th
mergefields contained in the document. Thus, all four pages get merge
each time - which is not what I want to happen.

Can anyone help me with this

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Doug Robbins - 19 Sep 2004 11:26 GMT

It would be the data source that you need to interrogate rather than the
merged document.
See the article "Access a database and insert into a Word document the data
that you find there" at:

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I need to automatically print specific pages of a 4 page mail merge
> document based on the content of a couple of mergefields.
[quoted text clipped - 8 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message