On Tue, Jun 23, 2009 at 10:44 PM, Daryl Colquhoun<atw@xxxxxxxxxxxxx> wrote: > OK, so it seems you have a CSV file along these lines > > Mickey Mouse &,Minnie Mouse,Cheese St,Trapville > Scrooge McDuck,Money Bin,Duckberg > Correct > ... > But I sort of sense (and correct me if I'm mistaken) that you're trying to > set it up so that Word non-power users can manage it _in one step_, Correct again - I do want to avoid changing the "workflow". > ... > How were they managing before? They were putting up with the joint names on 2 lines. We have convinced them to continue with this - and we will see how much effort is involved in changing the system that generates the CSV file (it's an old system). I tested the macrobutton approach, and I could pass information into and run a VBA macro, which did the other half of the job (checking for the &), but I couldn't automate it from the mail merge - I had to click the "click me" button. Thanks for the help - I think I needed to throw this out there to make sure I wasn't missing anything obvious. Cheers, Margaret > > ************************************************** 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 **************************************************