mail merge and switches

[michael steward]

I am applying a currency switch (\#$###0.00)to a
mergefield. This field may include multiple data. When I
do not have the switch on the data comes as 123.000. When
I use the switch it comes out as $123.00. All correct.
The issue I am having is when there is multiple fields
populated the currency field is SUMMED. I do not want the
sum, I want the individual data.

See Below:

Without Switch:
REFERENCE DATE AMOUNT
<DocField20> <DocDate> <DocAmt>
4120 9/26/2003 100.0000
3857 10/2/2003 100.0000
3922 10/10/2003 100.0000

With Switch:
REFERENCE DATE AMOUNT
<DocField20> <DocDate> <MrgfldDocAmt\#$##0.00>
4120 9/26/2003
3857 10/2/2003
3922 10/10/2003
$300.00

I want to see the following:
REFERENCE DATE AMOUNT
<DocField20> <DocDate> <DocAmt>
4120 9/26/2003 $100.00
3857 10/2/2003 $100.00
3922 10/10/2003 $100.00

How do I get the above results?

 

[Doug Robbins - Word MVP]

Hi Michael,

What type of mailmerge main document are you using?

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Doug Robbins - Word MVP]

Hi Michael,

What I meant, was it a formletter type maindocument or a catalog type main
document.

If you want to email me a copy of the document I will take a look at the
problem.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Michael Steward]

Hi Doug,
It is a form letter type main document. We use it as a
template for sending statements to our customers.
I am sending you an email of the document as requested.
Thanks for your help, I have asked everywhere and have
come up cold.
Michael

 

[Peter Jamieson]

If the fields have type "currency" in e.g. an Access table, there do seem to
be problems - in the specific case of Access it is probably better to create
queries that convert currency data to another type and use that as the basis
for your merge.

 

[Guest]

Hello Peter,
The database that I am using is MS SQL. And I do not have
permission to change the type of field in the db. Any
other way that you know of would be appreciated?
Michael

 

[Guest]

Hi Doug, I sent you requested info to your email address
as requested, was that what you wanted me to do as I have
not heard back from anyone yet? Your help is appreciated.
Michael

 

[Peter Jamieson]

Hm, if the data is in SQL Server then it may be a different problem - most
of the occurences of this seem to be with Access and Excel. But the
following are possibilities, depending on what you are allowed to do and
what tools you have:
a. create a view in SQL Server that uses a CONVERT/CAST or suitable formula
to convert the data
b. create a query in MS Query (or using the VBA OpenDataSource statement in
Word) that does more or less the same thing as (a) but does not require you
to create anything in SQL Server
c. create an MS Access database that links to the SQL Server table, and use
a query in Access to convert the data.

Which of those is available to you? My guess is (b), but do you have MS
Query on your system?