Send named Workbook to Outlook

[Annette]

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 = "(e-mail address removed)"
Subj = CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
.... (there is more, I am just hung up on the name)
__________
Thanks for any help!

 

[Ron de Bruin]

Hi Annette

If you use Outlook the look at the other examples on my site
The example you posted send text in the body with Outlook Express

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