I remember that if a mergefield was not used in the merge process, the field did not show up in the result. I guess you know that. I am sorry I can't help anymore Margaret! Regards, Warren -----Original Message----- From: austechwriter-bounce@xxxxxxxxxxxxx [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Margaret Hassall Sent: Monday, 22 June 2009 17:37 To: austechwriter@xxxxxxxxxxxxx Subject: atw: Re: mail merge question The problem is, if there is only one name then (nameadd2) contains the first address line, and I only want names on the one line. The data comes in a .csv file; I know the first line is always a name, but I can't tell where the names end and the address lines start without doing a check. So I have to test if (nameadd1) ends in "&", then I follow it with (nameadd2), otherwise start a new line. I am trying out the macro button info from the Word MVP site, at: http://word.mvps.org/FAQs/TblsFldsFms/UsingMacroButton.htm and this looks promising, but it is complicated. I can pass in the merge field (using private) but I'll have to put results in a property or something like that - still have work to do. I'd still like to hear about using text processing functions in a merge field. Thanks for the ideas. -----Original Message----- Sent: Monday, 22 June 2009 4:54 PM To: austechwriter@xxxxxxxxxxxxx Subject: atw: Re: mail merge question 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! --- 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 **************************************************