Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic Email Help Excel 2000 Req!
Dear all,
I'm a bit of a newbie but been getting on OK with macros/Visual Basic using Excel 2000. Can somebody please explain in simple terms how I can write a macro to send an email, lets suppose I have vairables: recipient and subject. I want the message body to be quite complex can I simply copy and paste data from a work sheet into my message body? What commands do I need to send an email? Also I would like to know if it is possible to format a cell as an email address, if the contents have been placed in the cell by a variable? If I tye an email address into a cell then it formats as defaut to an email address, but when I use VB to change a cell containing an email address the address is in plain text and not a hyperlink. TIA Zeta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic Email Help Excel 2000 Req!
Take a look at these sites:
Ron de Bruin's site http://www.rondebruin.nl/sendmail.htm http://www.rondebruin.nl/index.html Dick Kusileka's site http://www.dicks-clicks.com -- Regards, Tom Ogilvy Zeta wrote in message ... Dear all, I'm a bit of a newbie but been getting on OK with macros/Visual Basic using Excel 2000. Can somebody please explain in simple terms how I can write a macro to send an email, lets suppose I have vairables: recipient and subject. I want the message body to be quite complex can I simply copy and paste data from a work sheet into my message body? What commands do I need to send an email? Also I would like to know if it is possible to format a cell as an email address, if the contents have been placed in the cell by a variable? If I tye an email address into a cell then it formats as defaut to an email address, but when I use VB to change a cell containing an email address the address is in plain text and not a hyperlink. TIA Zeta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error sending email (as attachment) from within Excel 2000 | Excel Discussion (Misc queries) | |||
How to send a single page email from excel 2000 using outlook xp | Excel Worksheet Functions | |||
Excel 2000/Visual Basic -- I need to learn... | Excel Discussion (Misc queries) | |||
send email from Excel 2000 | Excel Discussion (Misc queries) | |||
make appointment in outlook and send email reminder - all data in excel 2000 | Excel Programming |