Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just tried to add other recipients other than my test self to the email and
it still send to me. Even after I totally removed my email and inserted another person - it sent the email solely to me. Any thoughts? Sub SalesandLisaEmail() Dim Outlook Set Outlook = CreateObject("Outlook.Application") Dim Message Set Message = Outlook.CreateItem(olMailItem) With Message .Subject = "New Issue" & " - " & ActiveSheet.Range("h5").Value .body = "There is a new B55 Checklist for review." & vbNewLine & vbNewLine & "After you've had a chance to review and sign off on the Checklist, please forward to the DMS Group for final review." & vbNewLine & vbNewLine & "Thank you - DMS Group." Application.DisplayAlerts = False .Recipients.Add ") Const olOriginator = 0 If Len(aFrom) 0 Then .Recipients.Add(aFrom).Type = olOriginator .Send End With Call Clear End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to catch the second or more cell with vlookup | Excel Worksheet Functions | |||
Anyone have troubles running 2003 macros in 2000 version of Excel | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
How do I 'catch' a 'delete cells' event | Excel Discussion (Misc queries) |