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 2005

Tip: Looking for answers? Try searching our database.

Formatting a word mailmerge with Excel data source

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tracey - 10 Mar 2005 10:51 GMT
Using XP Word mailmerge that has worked perfectly before, but now XP is
removing the Formatting from my Excel data source.  The currency has no
zero's WHY?
Peter Jamieson - 10 Mar 2005 15:40 GMT
How are you connecting to the Excel data source? If you have entered numbers
(say 100, 200, 300) in your Excel sheet then formatted them using Format
Cells to have 2 decimal places, the default connection method in Word
(OLEDB) will still see the numbers as 100, 200, 300. If you use DDE to
connect (check Word Tools|Options|General|"Confirm conversion at open" and
go through the connection process again, and select the DDE option when it
is offered) you will probably see the currency amounts the way you see them
in Excel. Or you can apply formatting in Word by using Alt-F9 to see the
field codes and changing, e.g.

{ MERGEFIELD mycurrency \*Mergeformat }

to e.g.

{ MERGEFIELD mycurrency \#"0.00" \*Mergeformat }

If absolutely nothing has changed in the way you are working and you haven't
installed any updates to Office etc., then it is certainly strange that the
behaviour of Word+Excel has changed, but the above approaches are the main
ways I know to fix the problem anyway.

Peter Jamieson
> Using XP Word mailmerge that has worked perfectly before, but now XP is
> removing the Formatting from my Excel data source.  The currency has no
> zero's WHY?
Old Bob - 15 Mar 2005 15:07 GMT
For me new with Office 2003 and fairly basic mail merge functions, this
option works great instead of the complicted "switches" that might be needed
for more intence mail merge.  the only issue it that, like in previous Office
versions, the excel spreadsheet you are selecting, the sheet you want the
information from must be in the first slot..no option to select which sheet.  
I am glad I kept reading  on this discussion board.  

> How are you connecting to the Excel data source? If you have entered numbers
> (say 100, 200, 300) in your Excel sheet then formatted them using Format
[quoted text clipped - 21 lines]
> > removing the Formatting from my Excel data source.  The currency has no
> > zero's WHY?
 
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.