Add date + 9 in word 2000 mail merge

[stubnski]

Hi VB experts!

I have a mail merge document in word 2000 with a merge field named effective_date. I need to insert a date 9 days in advance of the effective date (effective_date + 9).

Ex. effective_date = 5-1-06
date to be inserted = 5-10-06
NEXT DAY -
effective_date = 5-2-06
date to be inserted = 5-11-06...

The effective_date can be anywhere from 1 to 3 days older then the current date.

I need to insert this date twice in the mail merge document. The data source is a .txt file and is made daily.

I'm trying to find a way to keep things simple for the people who will be running the merge because they are computer illiterate.

Thanks in advance!

Stubnski

 

[johnwm]

This is VB6 forum. For VBA try forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[stubnski]

Oooop's Sorry. Thanks for the pointer to the right forum.