Maybe you can use this from Debra Dalgleish's site:
http://contextures.com/xlForm03.html


nobbyknownowt wrote:

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

--
nobbyknownowt

--

Dave Peterson