Email more than one objects to same person

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

Hi,

First off, I am working with an .adp file using a SQL
Server and I have 2 stored procedures I need to email in
an Excel format. I can get the SendObject macro to put
one of those in and email, then produce another email with
the second object.

Is there a way to have SendObject send more than one
attachment at a time?

Thanks in advance,
Megan
 
Not with SendObject Macro. You need to write VBA code using Outlook
Automation or CDO or MAPI.
 
This may sound complicated but it works very well
Create a macro with two transfer spreadsheet commands in
it to the same workbook. In Excel create a macro that
emails this workbook. Add to the macro a "RunApp" command
that includes the name of the Excel macro. A little
hoakie but my users only want to push buttons.

I do this in code so I use the "sendobject" and hardcode
the excel file name and bypass the "RunApp" and Excel
macro.

Jim
 
Back
Top