Hi,
I am not sure if this is possible or not. I currently have an excel worksheet template which contains a table EG Sheet1, A3:F100. Each month I use this excel template to send out emails using an email template to a number of individual people, each person recieves different data. I have VBA coding to arrange this on the template but what I can't work out is how I can copy the table accross to the email template to include it in a specific part of the email template. EG. line 15.
also I have the person's email address in cell A2 and want to copy it over to the reciepient address at the same time as copying the table over.
I probbaly have made sense but if anyone has an ideas I would love to hear it,
Regards
Mhuddles1981
Bookmarks