split one excel cell into 2 ms word fields in mail merge

[lena]

I'm doing a mail merge from excel into word. i have a field (cell) in excel
that i want to split into 2 separate fields in word. is this possibe? if so,
how can it be done?

thanks

 

[Peter Jamieson]

Generally speaking, Word's mailmerge fields can't do this kind of thing.
If you can construct two excel formulas that get the 1st and 2nd parts
of the field respectively, and create two new columns to contain them,
that's probably the simplest approach.

Otherwise, you may be able to use Word VBA and some SQL to do something
similar, or perhaps Word VBA and Word mailmerge Events.

Peter Jamieson

http://tips.pjmsn.me.uk