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