Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
tony
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
print mail merge data source i.e entire list? davidorlinda Mailmerge 2 December 1st 05 06:33 PM
Excel data truncated to 255 chars in Word Mail Merge Angie M Mailmerge 0 September 14th 05 04:51 PM
multiple docs, one data source kp Mailmerge 12 January 31st 05 04:41 PM
Mail merge data source problem campwes Mailmerge 1 January 25th 05 07:16 PM
How do I print a mail merge data source without the main document Lynn A Mailmerge 0 January 21st 05 10:39 AM


All times are GMT +1. The time now is 10:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"