[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]

I already posted a reply to your other message, as follows...

(It's simpler if you do not post the same message separately to multiple
groups - also, don't expect an immediate response!)

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

Peter Jamieson

http://tips.pjmsn.me.uk

lena wrote:
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