Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
I have a database created in Access, and am pulling info from it to create
letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
Hi MDI Anne,
The MERGEFIELD solution depends on whether you're dealing with a day, month & year, month & year or just a year. If its the last of these, it's simply a matter of embedding your MERGEFIELD in a FORMULA field coded like: {={MERGEFIELD "Expiration_Date"}+1} For anything more complicated, check out the entries under 'Calculate a month and year, using n years delay' and 'Calculate a day, date, month and year, using n years delay' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 To use either of those fields, you could replace the 'DATE' references with your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add another SET field, like: {SET ExpDate {MERGEFIELD "Expiration_Date"}} immediately above or below the '{SET Delay 1}' line and replace the 'DATE' references with 'ExpDate'. Cheers -- macropod [MVP - Microsoft Word] "MDI Anne" wrote in message ... I have a database created in Access, and am pulling info from it to create letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
Mac...
Have tried your formula suggestion and I get the following... !Syntax Error, { and yes, all that I want to do is add a year to the date... "macropod" wrote: Hi MDI Anne, The MERGEFIELD solution depends on whether you're dealing with a day, month & year, month & year or just a year. If its the last of these, it's simply a matter of embedding your MERGEFIELD in a FORMULA field coded like: {={MERGEFIELD "Expiration_Date"}+1} For anything more complicated, check out the entries under 'Calculate a month and year, using n years delay' and 'Calculate a day, date, month and year, using n years delay' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 To use either of those fields, you could replace the 'DATE' references with your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add another SET field, like: {SET ExpDate {MERGEFIELD "Expiration_Date"}} immediately above or below the '{SET Delay 1}' line and replace the 'DATE' references with 'ExpDate'. Cheers -- macropod [MVP - Microsoft Word] "MDI Anne" wrote in message ... I have a database created in Access, and am pulling info from it to create letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
You will get a syntax error if you haven't entered it correctly. You need to
use CTRL+F9 for the field boundaries. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MDI Anne wrote: Mac... Have tried your formula suggestion and I get the following... !Syntax Error, { and yes, all that I want to do is add a year to the date... "macropod" wrote: Hi MDI Anne, The MERGEFIELD solution depends on whether you're dealing with a day, month & year, month & year or just a year. If its the last of these, it's simply a matter of embedding your MERGEFIELD in a FORMULA field coded like: {={MERGEFIELD "Expiration_Date"}+1} For anything more complicated, check out the entries under 'Calculate a month and year, using n years delay' and 'Calculate a day, date, month and year, using n years delay' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 To use either of those fields, you could replace the 'DATE' references with your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add another SET field, like: {SET ExpDate {MERGEFIELD "Expiration_Date"}} immediately above or below the '{SET Delay 1}' line and replace the 'DATE' references with 'ExpDate'. Cheers -- macropod [MVP - Microsoft Word] "MDI Anne" wrote in message ... I have a database created in Access, and am pulling info from it to create letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
Graham, you were totally correct! So, I entered it in using the
CTRL+F9...now all I get is the number 1. This is so frustrating, not because of the awesome help I'm getting, but because I know things can be done...but only know enough to get myself into trouble! "Graham Mayor" wrote: You will get a syntax error if you haven't entered it correctly. You need to use CTRL+F9 for the field boundaries. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MDI Anne wrote: Mac... Have tried your formula suggestion and I get the following... !Syntax Error, { and yes, all that I want to do is add a year to the date... "macropod" wrote: Hi MDI Anne, The MERGEFIELD solution depends on whether you're dealing with a day, month & year, month & year or just a year. If its the last of these, it's simply a matter of embedding your MERGEFIELD in a FORMULA field coded like: {={MERGEFIELD "Expiration_Date"}+1} For anything more complicated, check out the entries under 'Calculate a month and year, using n years delay' and 'Calculate a day, date, month and year, using n years delay' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 To use either of those fields, you could replace the 'DATE' references with your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add another SET field, like: {SET ExpDate {MERGEFIELD "Expiration_Date"}} immediately above or below the '{SET Delay 1}' line and replace the 'DATE' references with 'ExpDate'. Cheers -- macropod [MVP - Microsoft Word] "MDI Anne" wrote in message ... I have a database created in Access, and am pulling info from it to create letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mergefield question
That's what will happen if the expiration date is a complete date and not
simply a year. You need to read the link macropod posted and download his date field file - then modify the appropriate field as indicated earlier in the thread. You should be able to get away with {MERGEFIELD Expiration_Date \@ "d MMM "}{={MERGEFIELD Expiration_Date \@ "YYYY"} + 1} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MDI Anne wrote: Graham, you were totally correct! So, I entered it in using the CTRL+F9...now all I get is the number 1. This is so frustrating, not because of the awesome help I'm getting, but because I know things can be done...but only know enough to get myself into trouble! "Graham Mayor" wrote: You will get a syntax error if you haven't entered it correctly. You need to use CTRL+F9 for the field boundaries. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org MDI Anne wrote: Mac... Have tried your formula suggestion and I get the following... !Syntax Error, { and yes, all that I want to do is add a year to the date... "macropod" wrote: Hi MDI Anne, The MERGEFIELD solution depends on whether you're dealing with a day, month & year, month & year or just a year. If its the last of these, it's simply a matter of embedding your MERGEFIELD in a FORMULA field coded like: {={MERGEFIELD "Expiration_Date"}+1} For anything more complicated, check out the entries under 'Calculate a month and year, using n years delay' and 'Calculate a day, date, month and year, using n years delay' in my Date Calc 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=249902 To use either of those fields, you could replace the 'DATE' references with your {MERGEFIELD "Expiration_Date"} field. Alternatively, you could add another SET field, like: {SET ExpDate {MERGEFIELD "Expiration_Date"}} immediately above or below the '{SET Delay 1}' line and replace the 'DATE' references with 'ExpDate'. Cheers -- macropod [MVP - Microsoft Word] "MDI Anne" wrote in message ... I have a database created in Access, and am pulling info from it to create letters. I have an expiration date in the database that, when put into my letter, I would like to add 1 year to the date. {MERGEFIELD "Expiration_Date"} I've tried doing a +1, and variations of that, but am getting no where. Any help would be greatly appreciated. Thanx!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Condition Question | Mailmerge | |||
Exam question wrong about Word? Opinions, please! | New Users | |||
mail merge with 2 different last names to the same address | Mailmerge | |||
Supress blank lines | Mailmerge | |||
formatting from a database in Word 2003 | Mailmerge |