Re: Using dates during mail merge

You can compare a date in a field with the current date with your skipif
field

{SKIPIF {Mergefield DateField \@ "yyyyMMdd"} <> {Date \@ "yyyyMMdd"}}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

gjupp via OfficeKB.com wrote:
Thanks for the reply.

For the data source we are using a standard word doc generated by
mail merge, using standard fields for names, address, etc, and we
assumed that dates would be retained in separate fields in each
record.

For the moment, until the 'system' is set up, we are entering the
current date manually in date fields for relevant records, then using
skip-if (not equal to this date) to merge only those records. This
retains the date but is crude indeed, as the skip-if date criterion
has to be changed for each merge. There must be a better way. Hope
you can help to streamline the process. Thanks.




Doug Robbins - Word MVP wrote:
What are you using for the data source? Frankly, it does not sound
to me like mail merge is really the best option for this. How are
you proposing to retain each date in the data source? In a new
record? In separate fields in each record, or multiple dates in one
field?

These sort of things need to be considered in the first instance.

Can anybody help please?

[quoted text clipped - 18 lines]

Many thanks in anticipation.


.

Relevant Pages

  • Re: How to remove automatically some pages?
    ... Word MVP web site http://word.mvps.org ... separately without the extra character. ... I used the macro to the big MailMerge output file and it ...
    (microsoft.public.word.newusers)
  • Re: How to remove automatically some pages?
    ... Word MVP web site http://word.mvps.org ... pages using tha macro from you. ... separately without the extra character. ...
    (microsoft.public.word.newusers)
  • Re: How to remove automatically some pages?
    ... Please tell me where is your e-mail address on your web site. ... Word MVP web site http://word.mvps.org ... separately without the extra character. ... After the process of MailMerging I delete the "extra" pages using the macro from ...
    (microsoft.public.word.newusers)
  • Re: How to remove automatically some pages?
    ... Best regards ... Please tell me where is your e-mail address on your web site. ... Word MVP web site http://word.mvps.org ... After the process of MailMerging I delete the "extra" pages using the macro from ...
    (microsoft.public.word.newusers)
  • Re: Word closing down
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... emptied the Template folder (including the subfolders Document Themes ...
    (microsoft.public.word.docmanagement)