Is it possible for excel to auto write a letter using data that has been entered on a worksheet.
For example if the cells a1:a6 are designated for name inputs on the worksheet and cells a7 are designated for action a8 for location
a1="tom" a2="dick" a3="harry" A4="" A5="" & a6="" a7="drive" a8="london"

Could vba code write "dear tom,dick & harry" please drive to london
and so on down a list of inputs.

If i can have a starting point I think I should be able to develop the code!?!??

Thanks for any suggestions

Cheers
Nobby