Email Attachment from Excel using Outlook.
 

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

--
Message posted from http://www.ExcelForum.com

Email Attachment from Excel using Outlook.
 

Pyball wrote:
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.


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

Email Attachment from Excel using Outlook.
 

Bill,

Thanks for the link. It is exactly what I am looking for.


---
Message posted from http://www.ExcelForum.com/