Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I have the following bit of code which will send the excel workbook as an attachment. I have it enter in the subject and set the flag for read recipt to true but how do i enter some text into the main message body. Application.EnableAnimations = False Application.ScreenUpdating = False Range("D6").Select Userid = ActiveCell.FormulaR1C1 Range("C28").Select Addressee = ActiveCell.FormulaR1C1 Subject = "CC:PY:INFO03: " + Userid ActiveWorkbook.Title = Subject ActiveWorkbook.Subject = "EPG" Application.EnableAnimations = True Application.ScreenUpdating = True ActiveWorkbook.SendMail Addressee, Subject, True MsgBox "This form has been sent to Desk Europe. A copy is stored in your Outlook Sent Folder." On Error GoTo 0 End Sub Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
send email from excel | Excel Discussion (Misc queries) | |||
Can't send email from Excel with CDO | Excel Programming | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
send email through Excel | Excel Programming |