Email Attachment from Excel using Outlook.

  • Thread starter Thread starter Pyball
  • Start date Start date
P

Pyball

Hello All,

I have a workbook the save a worksheet to a .txt file.

What I need to figure out is how to have the user enter an emai
address into an input box then have the New email message ready to g
with the To: line filled in, and the subject line fill in with
default subject, and the saved .txt file as an attachment.

Is this possible or am I asking too much
 
Pyball said:
What I need to figure out is how to have the user enter an email
address into an input box then have the New email message ready to go
with the To: line filled in, and the subject line fill in with a
default subject, and the saved .txt file as an attachment.
Click to expand...

All the options for sending email from Excel are well described at

http://www.rondebruin.nl/sendmail.htm

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top