merge exel

[verluc]

I have an excel workbook with two sheets: A and B
In sheet A, column A are several e-mail adresses.
In sheet B is the body-text for the e-mail.
How can I merge sheet B into each mail who are in column A.
The macro to send each e-mail is already working but not the merge with sheet B
Who can help?
Many thanks

 

[Jack in the UK]

Hi

I recall i once had an excel sheet that will bulk email via text in excel cells as you discribe its VBA heavy, i nabbed it from some where email me ill email you make what you can

Sorry to theh coder its really good 2 at my work use it,i bastardised it so simple use, i cant recall how you are, but credit you regardless and big thanks, also sorry i forgot who you are.