Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
split one excel cell into 2 ms word fields in mail merge
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
split one excel cell into 2 ms word fields in mail merge
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split one excel cell into 2 ms word fields in mail merge | Microsoft Word Help | |||
HOW DO I MAIL MERGE AN EXCEL CELL WITH CURRENCY FORMATING . | Mailmerge | |||
Word mail merge to Excel fields | Microsoft Word Help | |||
Fields in Excel not found in Mail Merge, Word | Mailmerge | |||
Mail Merge does not accept formatted cell of Excel | Mailmerge |