View Single Post
  #4  
Old February 5th, 2008, 09:33 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default 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.