Excel Mail Merger Problem

[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)?

 

[David McRitchie]

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.

 

[AKelly]

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

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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)?

.

 

[David McRitchie]

Didn't say that, did you look at the references. Every
one of them is a solution.

 

[Leo Heuser]

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.

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

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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)?

.