Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone please advise on the proper syntax for attaching more than one
file to a message? The error occurs at: .Attachments.Add FilenameStr2 Thanks, Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) 'On Error Resume Next With OutMail .To = emails .CC = "" .BCC = "" .Subject = "Hourly TAT Performance: " & _ Worksheets("Labels").Cells(4, i).Value & " - " & _ Sheets("Main").Range("AB8").Value .Body = "Reports attached" ' .BodyFormat = olFormatPlain 'testing for text format .Attachments.Add FilenameStr .Attachments.Add FilenameStr2 .Attachments.Add FilenameStr3 .Attachments.Add FilenameStr4 .Send 'or use .Display End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Attaching an Excel File to an Email | Excel Discussion (Misc queries) | |||
Attaching an Outlook email into a cell | Excel Discussion (Misc queries) | |||
Closing and attaching spreadsheet to an email | Excel Programming | |||
Attaching One Worksheet to Email | Excel Programming | |||
attaching tabs to email | Excel Discussion (Misc queries) |