Mail Merge with unequal number of fields

  • Thread starter Thread starter Mack
  • Start date Start date
M

Mack

I receive a monthly report showing search engine-generated web site hits. Included is name/address/contact info and the information category for which they were searching. I want to use this information to drive a Word MailMerge to create a response to each of these inquirers. I want to be able to address the area of interest that brought them to the site.

The problem is that one person may have searched on one subject (a single field/column) and another may have searched on 20. I can concatenate the cells, but how do I collect the cells to add together when each record has a different number of columns from which to draw the information?

Mack Neff

--
 
Concatenate ALL of the fields for All of the records. The Blank fields
will only add nothing.
 
Concatenate all the category cells into one, and use that cell in the
mail merge. For example, a formula for three columns:

=B2 & IF(C2="","",", " & C2) & IF(D2="","",", " & D2)
 
Back
Top