Email Macro o send Outlook Email

**asivaprakash** · 06-01-2013, 04:25 PM

Hi ,

I have completed writing the macro to send an email from excel to mail address.However these are my challenges

1.I want the mail to be reviewed before it is sent but it goes out automatically.

2.Also multiple windows open when the macro is run

I have searched the forum there is none similar.

Any one can help

SP

**TMS** · 06-01-2013, 06:25 PM

Take this out:

Please Login or Register  to view this content.

And press send yourself.

You are looping from rows 2 to 4 and you send the email in each iteration of the loop.

I'm guessing that you should move the send part outside the loop. But, it's your code so you presumably know what you're trying to do with it.

Why don't you just use the Outlook object model to send your emails?

Regards, TMS

**asivaprakash** · 06-01-2013, 07:05 PM

Worked well .I am just a guy trying to do stuff which will make things better for my guys.I m an amature.

One other thing.

It still open 3 outlook pages you know why sir.

With regards to the Outlook object model thats new to me any thing or anywhere i can know more