Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

Mailmerge on word using excel data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RJP - 08 Apr 2005 11:15 GMT
Hello.

I am trying to mailmerge a word document using data from an excel
spreadsheet. Despite the spreadsheet being formatted to English dates
(dd-mmmm-yy) and numbers to 0 decimal places when the documents merge the
dates show as American (mm/dd/yy) and the figures to 10 decimal places. I
have checked my system is set up in English format but am unaware of what
else can be done.

Any ideas.

Thanks.

RP
DB Queen (Not) - 08 Apr 2005 11:43 GMT
Have you tried going into the control panel and regiional options and date
and making sure that the default date setting is dd-mm-yy?

> Hello.
>
[quoted text clipped - 10 lines]
>
> RP
RJP - 08 Apr 2005 12:27 GMT
Unfortunately I have tried this and it does not solve the problem

> Have you tried going into the control panel and regiional options and date
> and making sure that the default date setting is dd-mm-yy?
[quoted text clipped - 13 lines]
> >
> > RP
Peter Jamieson - 08 Apr 2005 13:59 GMT
Usually you can solve these things if you use the DDE connection method - in
Word 2002/3 check Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and select the DDE option when
offered.

Otherwise, try using Alt-F9 in Word to view the raw fields and change, e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD//MM/YYYY" }

and

{ MERGEFIELD mynumber }

to something like

{ MERGEFIELD mynumber \#0 }

There is more in Graham Mayor's article at

http://www.gmayor.com/formatting_word_fields.htm

If you can't get the month and date to appear in the right order using
\@"DD/M/YYYY", it is probably because of a problem in the OLEDB provider
that Word is probably using to get the data. The DDE approach should solve
that, but at one point Microsoft offered a fix - you would have to contact
their Customer Support Services for more info. on that.

Peter Jamieson

> Hello.
>
[quoted text clipped - 10 lines]
>
> RP
RJP - 11 Apr 2005 08:29 GMT
Your first suggestion has worked a treat and all is now fine for both the
dates and numbers.

Thank you for taking the time to suggest the solutions.

Regards.


> Usually you can solve these things if you use the DDE connection method - in
> Word 2002/3 check Tools|Options|General|"Confirm conversion at open", go
[quoted text clipped - 43 lines]
> >
> > RP

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.