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

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