atw: Re: mail merge question
- From: "Lewington, Warren J (WT)" <warren.lewington.ext@xxxxxxxxxxx>
- To: <austechwriter@xxxxxxxxxxxxx>
- Date: Mon, 22 Jun 2009 02:54:23 -0400
I think you are saying that the source data may have two names, a
primary-name (nameadd1) and a joint-name (nameadd2). This could mean the
"&" is in the primary-name content if there is a joint-name present for
the record?
If this is so, just add the joint-name merge field to the same line and
all should be sweet!
Otherwise if the merge document is preparing the joint-name entry
automatically with a "&" and a carriage return, then I suspect there is
a script or other equivalent running in the background which is possibly
doing the entering of the joint-name under the primary-name. Normally
mail merge style documents are quite "do as you are told" once they are
set up and everything is pretty plain to see...
Regards,
Warren
-----Original Message-----
From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Margaret
Hassall
Sent: Monday, 22 June 2009 16:23
To: austechwriter@xxxxxxxxxxxxx
Subject: atw: mail merge question
Hi all,
I have an old mail merge document that includes several name and address
fields called nameadd1, nameadd2, ... up to nameadd6.
The Name is usually the first field, and then you can have 1 or more
address lines. This is used currently to create letters with the
name/address block showing through the envelop window.
If there is a joint name, the first line ends with "&" and the next
field has the second name. Something like ...
Mickey Mouse &
Minney Mouse
Fantasy Land
Disney Land
USA
Now, if there is more than one name I want to print it on the same line.
The data is from a system that is too old and entrenched so I don't
think I can change the source formats.
I want to say, with merge fields, something like ...
If the previous field ends with "&", then print on same line
but I can't work our how to compare the last character in a field. I
have tried using the RIGHT function that works in VBA, but it does
nothing in the mail merge - can I use this type of text processing
function in a merge, or do I just have the syntax wrong, ...
{ IF { RIGHT( {mergefield "nameadd1" }, 1)} = "&" {mergefield
"nameadd2" } "" }
Has anyone used a macro button in a merge to run a macro and return a
value - not sure if that is a possibility?
Thanks,
Margaret Hassall
---
This email and any files transmitted with it are solely intended for the
use of the addressee(s) and may contain information that is confidential
and privileged. If you receive this email in error, please advise us by
return email immediately. Please also disregard the contents of the
email, delete it and destroy any copies immediately.
Computershare Limited and its subsidiaries do not accept liability for
the views expressed in the email or for the consequences of any computer
viruses that may be transmitted with this email.
This email is also subject to copyright. No part of it should be
reproduced, adapted or transmitted without the written consent of the
copyright owner.
**************************************************
To view the austechwriter archives, go to
www.freelists.org/archives/austechwriter
To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx
with "unsubscribe" in the Subject field (without quotes).
To manage your subscription (e.g., set and unset DIGEST and VACATION
modes) go to www.freelists.org/list/austechwriter
To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************
**************************************************
To view the austechwriter archives, go to
www.freelists.org/archives/austechwriter
To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with
"unsubscribe" in the Subject field (without quotes).
To manage your subscription (e.g., set and unset DIGEST and VACATION modes) go
to www.freelists.org/list/austechwriter
To contact the list administrator, send a message to
austechwriter-admins@xxxxxxxxxxxxx
**************************************************
Other related posts: