Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do you only print new data in a mail merge - automatically
I have a word document tied to an access database which has a Field "Printed"
which is either True or False. I would like word to check the Printed Field and if it False then print the Form - and then convert the access Field to False - so that it is not printed again. Not even sure if this can be done - any ideas greatly accepted |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do you only print new data in a mail merge - automatically
You can use a Skip Record If field to check the value of the Printed field
(which will be -1) if it is a Yes/No field in Access and the record has been printed. Mailmerge in Word is however only a one-way affair, so there is no way, using the mailmerge utility alone, to update the value in the Access field. It can probably done via VBA using Mail Merge Events, but it may be a lot simpler to do it in Access. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "tony" wrote in message ... I have a word document tied to an access database which has a Field "Printed" which is either True or False. I would like word to check the Printed Field and if it False then print the Form - and then convert the access Field to False - so that it is not printed again. Not even sure if this can be done - any ideas greatly accepted |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print mail merge data source i.e entire list? | Mailmerge | |||
Excel data truncated to 255 chars in Word Mail Merge | Mailmerge | |||
multiple docs, one data source | Mailmerge | |||
Mail merge data source problem | Mailmerge | |||
How do I print a mail merge data source without the main document | Mailmerge |