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!
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!