Send named Workbook to Outlook

A

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!
 

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

Top