mail merge and switches

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michael steward - 20 Oct 2003 23:58 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 21 Oct 2003 10:34 GMT

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

> I am applying a currency switch (\#$###0.00)to a
> mergefield. This field may include multiple data. When I
[quoted text clipped - 29 lines]
>
> How do I get the above results?

Reply to this Message

Peter Jamieson - 25 Oct 2003 08:54 GMT

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.

--
Peter Jamieson
MS Word MVP

> I am applying a currency switch (\#$###0.00)to a
> mergefield. This field may include multiple data. When I
[quoted text clipped - 29 lines]
>
> How do I get the above results?

Reply to this Message

- 28 Oct 2003 18:27 GMT

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

>-----Original Message-----
>If the fields have type "currency" in e.g. an Access table, there do seem to
[quoted text clipped - 26 lines]
>> REFERENCE DATE AMOUNT
>> <DocField20> <DocDate>

<MrgfldDocAmt\#$##0.00>

>> 4120 9/26/2003
>> 3857 10/2/2003
[quoted text clipped - 11 lines]
>
>.

Reply to this Message

Peter Jamieson - 29 Oct 2003 00:54 GMT

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?

--
Peter Jamieson
MS Word MVP

> Hello Peter,
> The database that I am using is MS SQL. And I do not have
[quoted text clipped - 56 lines]
> >
> >.

Reply to this Message