I would like to be able to send email (using the default outlook
program) from an excel spreadsheet. I need some help! Any one have
the procedure to suggest? Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

McDowell,

What exactly to you want to do? Send the workbook, send a message to a
specific address, send out messages to a list, or send out a warning
based on a value in the workbook? I have posted many example of
sending email from Outlook using an Excel spreadsheet, based on
different criteria.

Do a Google groups search of microsoft.public.excel to find them, or
post back with more details.

HTH,
Bernie
MS Excel MVP

"mcdowell" wrote in message
...
I would like to be able to send email (using the default outlook
program) from an excel spreadsheet. I need some help! Any one have
the procedure to suggest? Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

Here are some possible sources of information:


Ron de Bruin
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/library/en...odc_xlmail.asp

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm


--
Regards,
Tom Ogilvy


"mcdowell" wrote in message
...
I would like to be able to send email (using the default outlook
program) from an excel spreadsheet. I need some help! Any one have
the procedure to suggest? Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

I really appreciate the responses.
I have a UserForm with a commandbutton adjacent to a text box. I
simply want to be able to open an outlook email using the commandbutton
and the text box value as the address. The user can then complete the
Email, send it and return to the Userform. This sounds simple, but I
need help on the code. Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Check out my website
http://www.rondebruin.nl/sendmail.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"mcdowell" wrote in message ...
I really appreciate the responses.
I have a UserForm with a commandbutton adjacent to a text box. I
simply want to be able to open an outlook email using the commandbutton
and the text box value as the address. The user can then complete the
Email, send it and return to the Userform. This sounds simple, but I
need help on the code. Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/