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 / March 2006

Tip: Looking for answers? Try searching our database.

Data frm excel to word using mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Param - 30 Mar 2006 17:33 GMT
Hi,
I am using mail merge to create report. I encounter problem when working
with and printing mail merge. I need solution for:
1) number from excel e.g 20, turn 20.0 in word.
2) percentage frm excel e.g 67%,  turn 67.33456 in word.
3) date from excel 30 March 2006, turn 30/3/2006 12:00pm

pls let me. Tq param
Peter Jamieson - 30 Mar 2006 19:40 GMT
Look up Word Help for field switches, e.g. so instead of

{ MERGEFIELD mydate }

you use

{ MERGEFIELD mydate \@"DD MMMM YYYY" }

Alternatively, revert to the old method (DDE) of link to Excel - check Word
Tools|Options|General|"Confirm conversions at open", go through the process
of connecting to your sheet again, and choose the DDE option when prompted.
This method is "deprecated", requires Excel on your system, and only works
with the sheet that excel opens by default - typically the first sheet in
the workbook.

Peter Jamieson

> Hi,
> I am using mail merge to create report. I encounter problem when working
[quoted text clipped - 4 lines]
>
> pls let me. Tq param

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.