Windows XP Creating MACROS

E

ElliTech

Joined
Jun 1, 2009
Messages
2
Reaction score
0
Hi,

As I am new to this I am in need of some help. I need to be able to pull information from an excel document using a macro. I want to be able to send individual emails using the email address as well as the associated user's name from an excel sheet suing a macro to send the emails one at a time.

How can this be accomplished?

Thanks...

ElliTech
 
Hi ElliTech, welcome to the forum. (I was just welcomed this morning, but I guess I can welcome you!)

I know this is a little old, but if you are still looking for the answer, here is what I use :

Dim EmailAddress(1 to 10)

For i = 1 to 10
EmailAddress(i) = Worksheets(1).Cells(i, 1).value
ActiveWorkbook.SendMail _
Recipients:=EmailAddress(i), _
Subject:="Here is the list of email addresses."
Next i

This macro would send the active workbook via email.

Joe
 
Macros

Hi Joe,

Thanks for taking the time to respond back to the post, better late than never. Oh, and welcome too...I will try out the macro soon as I have a little free time today or tommorow. Again, thanks for responding to the post.

ElliTech
 
Back
Top