atw: mail merge question
- From: "Margaret Hassall" <Margaret.Hassall@xxxxxxxxxxxxxxxxxxxx>
- To: <austechwriter@xxxxxxxxxxxxx>
- Date: Mon, 22 Jun 2009 16:23:26 +1000
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
**************************************************
Other related posts:
- » atw: mail merge question - Margaret Hassall
