Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
KC KC is offline
external usenet poster
 
Posts: 27
Default problem with mailmerge word 2003

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default problem with mailmerge word 2003

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003: Problem with Locked Form Fields and MailMerge ocean mist Mailmerge 1 February 27th 08 09:10 AM
Mailmerge Problem with Word in Office 2003 Ray S. Mailmerge 4 October 31st 07 12:56 AM
[2003] Mailmerge Problem with ODBC Josvds Mailmerge 0 November 7th 06 10:16 AM
Word 2003 MailMerge with SQL Server 2000 problem crm Mailmerge 3 October 9th 06 05:32 PM
Problem with Mailmerge in Word 2003 Nicci Mailmerge 1 February 17th 06 05:46 AM


All times are GMT +1. The time now is 01:36 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"