Hi

Take a look at Ron de Bruin's site for good information on what you are
trying to achieve
http://www.rondebruin.nl/mail/add-in.htm


--
Regards

Roger Govier



chelleyit
wrote:
Hi,

I have a spreadsheet that shows vacation time, business travel, and
other for different people. I want to be able to run a macro that
will email certain information pertaining to a certain person by
picking what they want to email from a list box and then having the
macro send a summary of the information to each person. I can't
really explain it properly, but I hope you get the gist of it.

I was able to modify a macro that I found online, but it can only
email going line by line. I don't want 20 different emails going to
one person. I want all information that pertains to that particular
person summarized in one email.

Thank you in advance for any assistance you might be able to offer.

Chelley


--
chelleyit
------------------------------------------------------------------------
chelleyit's Profile:
http://www.excelforum.com/member.php...o&userid=30059 View
this thread: http://www.excelforum.com/showthread...hreadid=497386