emailing single worksheet

[Guest]

I’ve adopted Ron de Bruin's macro to e-mail a single worksheet, but how do you change the recipient “on the fly�

My sheet extracts data for the selected individual from another sheet and I want to send that data to that individual, then clear their data and extract the next person’s data and send that to them.

Something that pauses the macro and prompts for the address is what I’m after I suppose.

Many Thanks,
Ken G.

 

[Ron de Bruin]

Hi Ken


http://www.rondebruin.nl/sendmail.htm#Tips

If you use this line you can choose a address in the address book or type one yourself.
And also you can type some text in the body.
.SendMail "", "This is the Subject line"


With Outlook code you can use Display instead of Send


--
Regards Ron de Bruin
http://www.rondebruin.nl

I've adopted Ron de Bruin's macro to e-mail a single worksheet, but how do you change the recipient "on the fly"?

My sheet extracts data for the selected individual from another sheet and I want to send that data to that individual, then clear

their data and extract the next person's data and send that to them.

 

[Guest]

Thanks Ron, I actually did something different with a look up table that grabs the email address when the name is entered and then the macro refers to the cell with the result of the lookup.

Next question is - can you put a standard message in the macro to go into the body of the e-mail?

 

[Ron de Bruin]

Only with Outlook
http://www.rondebruin.nl/sendmail.htm#Outlook

--
Regards Ron de Bruin
http://www.rondebruin.nl

Thanks Ron, I actually did something different with a look up table that grabs the email address when the name is entered and then

the macro refers to the cell with the result of the lookup.