merge exel

verluc · Mar 2nd, 2002, 05:24 AM

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 · Jul 22nd, 2002, 04:59 PM

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.

Jul 22nd, 2002, 04:59 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 2nd, 2002, 05:24 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,290	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