Excel and preparing email

[Stuart]

I can use Excel to prepare basic emails in "Outlook" through
VBA.......however is their any way to prepare emails from Excel that would
contain formatted text, hyperlinks, tables etc.

stuart

 

[Tom Ogilvy]

One of these sites should have your answer:

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

Dick Kuselika
www.dicks-clicks.com

Tim Zych
www.rubbershoe.com/olmail.htm