Excel Mail Merger Problem

  • Thread starter Thread starter AKelly
  • Start date Start date
A

AKelly

When merging excel with word for..my currrency field is
dropping off zeros to the right of decimal point..if
field has $ 56.03, it imports correctly, but if it is
$56.00, it comes in as $56, if it is $56.30, it comes in
as $56.3...this process is for invoices..any advice (I've
tried everything)?
 
Debra Dalgleish has given the following reply in newsgroups
http://google.com/[email protected]
and has also identified the following MS KB articles in
such as : http://google.com/[email protected]

304387 - WD: Date, Phone Number, and Currency Fields Are Merged Incorrectly
When You Use an Access or Excel Data Source
http://support.microsoft.com/default.aspx?scid=kb;en-ca;304387

320473 - WD2002: Excel Data Does Not Retain Its Formatting in Mail Merge Operations
http://support.microsoft.com/default.aspx?scid=kb;en-ca;320473

I think I will modify my mail merge instructions to include the MS KB 320473
line for DDE.
 
Please clarify...are we saying there is no solution>?
-----Original Message-----
Debra Dalgleish has given the following reply in newsgroups
40contextures.com
and has also identified the following MS KB articles in
such as : http://google.com/groups? threadm=3DFA8DA8.6000209%40contextures.com

304387 - WD: Date, Phone Number, and Currency Fields Are Merged Incorrectly
When You Use an Access or Excel Data Source
http://support.microsoft.com/default.aspx?scid=kb;en- ca;304387

320473 - WD2002: Excel Data Does Not Retain Its
Click to expand...
Formatting in Mail Merge Operations
 
Didn't say that, did you look at the references. Every
one of them is a solution.
 
No, David is asking you to click the hyperlinks to
get to articles explaining how to solve the problem.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top