A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

problem with mailmerge word 2003



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 04:04 AM posted to microsoft.public.word.mailmerge.fields
KC
external usenet poster
 
Posts: 215
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  
Old May 28th, 2010, 06:18 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.