Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date calculations
When using a Word form letter with mail merge is it possible to do
calculations with the date (today's date) value. Today's date would appear in the heading area. Then, I would like to have a date that is 14 days from the current date, any date the form letter is utilized, printed in the body of the letter used in the mailmerge. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date calculations
You can use the DateAdd() function in a macro
Selection.InsertBefore Format(DateAdd("d", 20, Date), "MMMM d, yyyy") Or, Macropod will probably come along and say: To see how to do this and just about everything else you might want to do with dates in Word, check out the topic 'Add Or Subtract Two Time Periods' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 -- 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 "TheFoz" wrote in message ... When using a Word form letter with mail merge is it possible to do calculations with the date (today's date) value. Today's date would appear in the heading area. Then, I would like to have a date that is 14 days from the current date, any date the form letter is utilized, printed in the body of the letter used in the mailmerge. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date calculations
This is more complex than you might imagine, but it can be done. See
http://addbalance.com/word/datefields2.htm for information on the different kinds of ways to make a date calculation work. It includes links to pages with fields and an explanation of different macros that can be used instead of fields. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "TheFoz" wrote in message ... When using a Word form letter with mail merge is it possible to do calculations with the date (today's date) value. Today's date would appear in the heading area. Then, I would like to have a date that is 14 days from the current date, any date the form letter is utilized, printed in the body of the letter used in the mailmerge. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date calculations
A big help. Thanks.
"Doug Robbins - Word MVP" wrote: You can use the DateAdd() function in a macro Selection.InsertBefore Format(DateAdd("d", 20, Date), "MMMM d, yyyy") Or, Macropod will probably come along and say: To see how to do this and just about everything else you might want to do with dates in Word, check out the topic 'Add Or Subtract Two Time Periods' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 -- 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 "TheFoz" wrote in message ... When using a Word form letter with mail merge is it possible to do calculations with the date (today's date) value. Today's date would appear in the heading area. Then, I would like to have a date that is 14 days from the current date, any date the form letter is utilized, printed in the body of the letter used in the mailmerge. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date calculations
Thanks for the help.
"Charles Kenyon" wrote: This is more complex than you might imagine, but it can be done. See http://addbalance.com/word/datefields2.htm for information on the different kinds of ways to make a date calculation work. It includes links to pages with fields and an explanation of different macros that can be used instead of fields. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "TheFoz" wrote in message ... When using a Word form letter with mail merge is it possible to do calculations with the date (today's date) value. Today's date would appear in the heading area. Then, I would like to have a date that is 14 days from the current date, any date the form letter is utilized, printed in the body of the letter used in the mailmerge. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Field Merge | Mailmerge | |||
Autotext date is not correct when used in Word | Microsoft Word Help | |||
The Web Archive Converter puts todays date on MHT copies of old f | Microsoft Word Help | |||
Document Creation Date | Microsoft Word Help | |||
Setting default headers and fonts in a template | Microsoft Word Help |