Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I send an Excel 2007 workbook to an Outlook Exchange folder | Excel Discussion (Misc queries) | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Cannot send out Excel workbook through Outlook Express | Excel Programming | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) |