Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching files to Outlook
I have an Excel macro that saves a workbook and sends it to a user at a
specific cost center. Part of the code I am using is below. I have a new requirement that other cost centers would like to attach backup files to support the Excel file that gets sent in the e-mail. I'm looking for some code or suggestions that will allow me to attach the other files to the e-mail before it is sent. I will have the paths to each backup file in a array. Is this possible? Thanks for the help ActiveWorkbook.SaveAs (vPath & vNewFileName) On Error GoTo errmsg ActiveWorkbook.SendMail ", "), Subject:=vNewFileName1 & " !B!A!C!K!U!P!S!" ActiveWorkbook.Close (False) MsgBox "Your file has been sent" Application.StatusBar = "Ready" Application.DisplayStatusBar = True -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching files to Outlook
Not possible with SendMail
If you use Outlook you can do it, see this site for the Outlook object model examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JT" wrote in message ... I have an Excel macro that saves a workbook and sends it to a user at a specific cost center. Part of the code I am using is below. I have a new requirement that other cost centers would like to attach backup files to support the Excel file that gets sent in the e-mail. I'm looking for some code or suggestions that will allow me to attach the other files to the e-mail before it is sent. I will have the paths to each backup file in a array. Is this possible? Thanks for the help ActiveWorkbook.SaveAs (vPath & vNewFileName) On Error GoTo errmsg ActiveWorkbook.SendMail ", "), Subject:=vNewFileName1 & " !B!A!C!K!U!P!S!" ActiveWorkbook.Close (False) MsgBox "Your file has been sent" Application.StatusBar = "Ready" Application.DisplayStatusBar = True -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Attaching a Read Receipt to Outlook E-mail | Excel Programming | |||
Attaching an Outlook email into a cell | Excel Discussion (Misc queries) | |||
Attaching Emails in Outlook Message Format | Excel Discussion (Misc queries) | |||
Attaching an Outlook Library programatically | Excel Programming | |||
Trouble attaching an Excel file in Outlook 2003 - Help | Excel Discussion (Misc queries) |