Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Superscripted date
Hi,
I have checked the posts to see if I could find a solution for my problem and found an answer and link to the site of Graham Mayor. I have tried to use the format he suggested for superscripted date but it constantly gives me an error. Is there something wrong with my field codes? My data source is in Excel and is formatted d mmmm yyyy. {QUOTE{MERGEFIELD Date \\@ dddd the d}{IF{=(mod({MERGEFIELD Date\@ d},10)4)*(mod({MERGEFIELD Date\@ d},10)0)*({MERGEFIELD Date\@ d}11*({ MERGEFIELD Date\@ d}12)*({ MERGEFIELD Date\@ d}13)}=1{=mod({MERGEFIELD Date\@ d},10)-2 \# rd;st;nd } th}{ MERGEFIELD Date\@ of MMMM, yyyy"}} |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Superscripted date
Rather than attempt to reproduce this code manually, which invites errors
(there's one in the first field - I didn't check any farther) download the document that contains the field code from the link at http://www.gmayor.com/insert_a_date_...than_today.htm. Paste the fields into your document and edit the DATE fields it contains to match the mergefield in your data source. Turn off the autoformat that changes straight quotes to smart quotes! If you can't work it out from that - contact me via the link on my web site home page, giving details of the date field name in your Excel data file - and what you want to do with it. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lupe wrote: Hi, I have checked the posts to see if I could find a solution for my problem and found an answer and link to the site of Graham Mayor. I have tried to use the format he suggested for superscripted date but it constantly gives me an error. Is there something wrong with my field codes? My data source is in Excel and is formatted d mmmm yyyy. {QUOTE{MERGEFIELD Date \\@ "dddd 'the' d"}{IF{=(mod({MERGEFIELD Date\@ d},10)4)*(mod({MERGEFIELD Date\@ d},10)0)*({MERGEFIELD Date\@ d}11*({ MERGEFIELD Date\@ d}12)*({ MERGEFIELD Date\@ d}13)}=1{=mod({MERGEFIELD Date\@ d},10)-2 \# rd;st;nd } th}{ MERGEFIELD Date\@ "'of' MMMM, yyyy"}} |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Superscripted date
Graham, I downloaded the zip file of Macropod on your page "Formatting Word
fields with switches" and I got my answer. Thanks! Lupe "Graham Mayor" wrote: Rather than attempt to reproduce this code manually, which invites errors (there's one in the first field - I didn't check any farther) download the document that contains the field code from the link at http://www.gmayor.com/insert_a_date_...than_today.htm. Paste the fields into your document and edit the DATE fields it contains to match the mergefield in your data source. Turn off the autoformat that changes straight quotes to smart quotes! If you can't work it out from that - contact me via the link on my web site home page, giving details of the date field name in your Excel data file - and what you want to do with it. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lupe wrote: Hi, I have checked the posts to see if I could find a solution for my problem and found an answer and link to the site of Graham Mayor. I have tried to use the format he suggested for superscripted date but it constantly gives me an error. Is there something wrong with my field codes? My data source is in Excel and is formatted d mmmm yyyy. {QUOTE{MERGEFIELD Date \\@ "dddd 'the' d"}{IF{=(mod({MERGEFIELD Date\@ d},10)4)*(mod({MERGEFIELD Date\@ d},10)0)*({MERGEFIELD Date\@ d}11*({ MERGEFIELD Date\@ d}12)*({ MERGEFIELD Date\@ d}13)}=1{=mod({MERGEFIELD Date\@ d},10)-2 \# rd;st;nd } th}{ MERGEFIELD Date\@ "'of' MMMM, yyyy"}} |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concerning Current Date Changes On Past Documents | Microsoft Word Help | |||
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 |