I'm setting up a mail merge document. I need to be able to check if one date
is greater than or equal to 14 days and if so insert a certain piece of text
into the document. I've tried to set up a procedure called CheckDate and
then use DateDiff to calculate the number of dates but I can't get it to run.
Can anyone help?

Is your problem within the procedure, or getting the procedure to run?

It's not easy to run macros within the context of a mailmerge. Another
approach is to put the calculation within the MailMerge query itself --
IIF([DateField 1] = [DateField 2] + 14), "Text if yes", "Text if no"), ...





"webXpeerience" wrote in message
...
I'm setting up a mail merge document. I need to be able to check if one
date
is greater than or equal to 14 days and if so insert a certain piece of
text
into the document. I've tried to set up a procedure called CheckDate and
then use DateDiff to calculate the number of dates but I can't get it to
run.
Can anyone help?

The field calculations required to do this in the Word document are
complex - see the linked article at
http://www.gmayor.com/insert_a_date_...than_today.htm

--

Graham Mayor - Word MVP

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


webXpeerience wrote:
I'm setting up a mail merge document. I need to be able to check if
one date is greater than or equal to 14 days and if so insert a
certain piece of text into the document. I've tried to set up a
procedure called CheckDate and then use DateDiff to calculate the
number of dates but I can't get it to run. Can anyone help?