Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ive created an outlook email in a macro using the following code;
'Control Microsoft Outlook and create a new Email Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItem(olMailItem) myItem.To = Worksheets("Sheet1").Cells(2, 17).Value 'Assign a Subject to the Email myItem.Subject = Worksheets("Sheet1").Cells(1, 1).Value 'Attach File to Mesage myItem.body = ??????? 'Send the Email myItem.Send As you can see I can't seam to figure out the Attach file command. Any help would be greatly appreciated. Thanks, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to attach doc.to an email? | New Users to Excel | |||
Attach Email to a Cell | Excel Discussion (Misc queries) | |||
attach outlook email | Excel Discussion (Misc queries) | |||
how do I attach spreadsheet in email | Excel Worksheet Functions | |||
attach to email | Excel Programming |