Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge date conversion
I have a mailmerge document with excel source data. I have date fields in
excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge date conversion
In response to your three(?) questions - From the Tools menu in Word, select
Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org tamee wrote: I have a mailmerge document with excel source data. I have date fields in excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge date conversion
Thank you so much for that! That's so much easier than toggling the fields
which doesn't work for my dates. "Graham Mayor" wrote: In response to your three(?) questions - From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org tamee wrote: I have a mailmerge document with excel source data. I have date fields in excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge date conversion
Hope you could help me again. How Do you align currency figures so that the
values are right justified or all decimal points aligned together? "Graham Mayor" wrote: In response to your three(?) questions - From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org tamee wrote: I have a mailmerge document with excel source data. I have date fields in excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge date conversion
See the answer to your other post! There is no need to post the same thing
in several places. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org tamee wrote: Hope you could help me again. How Do you align currency figures so that the values are right justified or all decimal points aligned together? "Graham Mayor" wrote: In response to your three(?) questions - From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org tamee wrote: I have a mailmerge document with excel source data. I have date fields in excel, but when I merge it reverts to the original serial number. How do I convert it back to display the desired date format. Please Help. Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MailMerge - File Conversion Problem | Microsoft Word Help | |||
Mailmerge date format | Mailmerge | |||
date mailmerge problem | Mailmerge | |||
US / English date format mailmerge | Mailmerge | |||
convert date format after mailmerge | Mailmerge |