Basic Email Help Excel 2000 Req!

Z

Zeta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email Bounce Error 3
Email Macro-using range for email address,ccc,bcc,subject and body.Office Outlook as email 3
Emailing out of Excel 3
Access Automatically Send a notification email once a record is added 0
email problem 2
OutLook Task and Appointment 1
Rows To Columns & Hyperlink to Email Address 0
Export Macro to new Workbook based on Email Address 7

Top