Can you spell out what
a. could be in this column
b. wat you mean by "EIN" ?
As background, there are (at least) two separate problems when using
Excel and a Mail Merge Data Source:
a. How do you ensure that your data reaches Word intact? (e.g., if the
first 8 rows in your column contain numbers, then the chances are that a
non-numeric text value in the column wi come across as 0)
b. even when the values reach Word intact, how do you decide that a
particular value needs to be formatted as (a) text, (b) numeric, (c)
date etc.
Peter Jamieson
http://tips.pjmsn.me.uk
On 28/04/2010 23:01, bushwood wrote:
How can you format a word 2007 mergefield a certain way depending on the type
of value it encounters in your excel 2007 data source during the mailmerge?
Basically, the merge will encounter blank record, EIN, or Address. We want
the special format switch if encounter EIN, and then if not all numeric just
pull the cell contents is fine.
Thanks for any help!