Rearrange your input data into consecutive cells starting in Cell A1. Leaving empty columns makes life so much harder.

Then explore mail merges before attempting a vba method.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia