[Yookaroo]

2) how can I add a soft return after a field but only if it exists, so there
is no space if there is no data in the field

3) as I have 16,000 records in 4 databases this is a big one for me, I have
41 columns and 41 products (Each product isnt named, its represented by a
number, but they dont always have product one in column 1, product 2 in
column 2... Some have product 6 in column 2 and product 7 in column 3 there
are a ton of different formats. Some people get all 41 some people get less.
So can I :

a) is there a way to format the excel file that will move the 2's under the
2 column, the 3's under the 3 column etc...?

b) Is there a way to tell mail merge that when it encounters a 1 in a field
to post product name 1, if it finds 2 post product name 2 etc...