Send named Workbook to Outlook
 

I have gotten as far as the code below for sending a workbook and can send
the workbook; however, I would like the saved name to appear on the
'Subject' line and the cursor to stop on the subject line so I can add more,
but don't know how to write this.

Sub Mail_Text_in_Body()
'In 2002 I can go to 600-700 characters
Dim Msg As String, URL As String
Dim Recipient As String, Subj As String, HLink As String

Recipient = "
Subj = CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
.... (there is more, I am just hung up on the name)
__________
Thanks for any help!

Send named Workbook to Outlook
 

Hi Annette

If you use Outlook the look at the other examples on my site

I have gotten as far as the code below for sending a workbook
The example you posted send text in the body with Outlook Express

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Annette" wrote in message ...
I have gotten as far as the code below for sending a workbook and can send the workbook; however, I would like the saved name to
appear on the 'Subject' line and the cursor to stop on the subject line so I can add more, but don't know how to write this.

Sub Mail_Text_in_Body()
'In 2002 I can go to 600-700 characters
Dim Msg As String, URL As String
Dim Recipient As String, Subj As String, HLink As String

Recipient = "
Subj = CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
... (there is more, I am just hung up on the name)
__________
Thanks for any help!