MailMerge and Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donny - 15 Mar 2004 17:48 GMT

Hi all
I hope someone can answer this Merge Quesyion.
I have the Merge Document with all needed fields getting
data from
my Access 2000 database. I enter data into database and
then print my documents.

My problem is that when I enter new data in and try to
merge and print
I get all data previously entered trying to reprint along
with my new data
just entered. I can put a new field in my database for
marking "AsPrinted=true"
but how do I get Word not to print documents already
printed.

I hope I ask this in the right way...

Please help!
Donny

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 16 Mar 2004 09:36 GMT

Click on the Query Options button and then use the Filter tab to set up a
filter to filter out the records that you have already merged, or create a
query in Access that will select only those records for which
AsPrinted=False and use that query as the data source.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hi all
> I hope someone can answer this Merge Quesyion.
[quoted text clipped - 16 lines]
> Please help!
> Donny

Reply to this Message