Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
ok so i've looked over here and have seen several suggestions that i thought
would work but so far i've had no luck. i have a mail merge document that imports data from excel 2003. everything seems to work fine except for 2 problems. 1 i can live with but if you can help me fix it it would be great. the other i need to fix. the problem i need to fix is the date entry i have on the mail merge document shows up as ######.### instead of DD/MM/yy hh:mm am/pm. the time and date are all one field because that is how the program i import that data into excel stores it. i've tried changing the source coding through options and i lose the field that contains the email addresses i need to send it to. when i tried using the (/@) format commands nothing happened. i suspect it is because the information is derived from a formula on the original spreadsheet. but am hoping someone has a way i can get this to work. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Word treats the merged information not as it is displayed but as it is
stored in Excel and with this format that is as a long decimal number. 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. Note however that DDE connections are flaky and this may not work reliably. In that case you will have to derive separate fields in your data source for date and time information from the original data. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "KC" wrote in message ... ok so i've looked over here and have seen several suggestions that i thought would work but so far i've had no luck. i have a mail merge document that imports data from excel 2003. everything seems to work fine except for 2 problems. 1 i can live with but if you can help me fix it it would be great. the other i need to fix. the problem i need to fix is the date entry i have on the mail merge document shows up as ######.### instead of DD/MM/yy hh:mm am/pm. the time and date are all one field because that is how the program i import that data into excel stores it. i've tried changing the source coding through options and i lose the field that contains the email addresses i need to send it to. when i tried using the (/@) format commands nothing happened. i suspect it is because the information is derived from a formula on the original spreadsheet. but am hoping someone has a way i can get this to work. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Word 2003: Problem with Locked Form Fields and MailMerge | Mailmerge | |||
Mailmerge Problem with Word in Office 2003 | Mailmerge | |||
[2003] Mailmerge Problem with ODBC | Mailmerge | |||
Word 2003 MailMerge with SQL Server 2000 problem | Mailmerge | |||
Problem with Mailmerge in Word 2003 | Mailmerge |