Windows XP Creating MACROS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top