[ElliTech]

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

[JoeBlow9878]

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

[ElliTech]

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

[Rush]

Wow ages since i saw a For, Next loop

[Madxgraphics]

Originally Posted by Rush

Wow ages since i saw a For, Next loop

HUH..???