Email more than one objects to same person

[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

 

[Van T. Dinh]

Not with SendObject Macro. You need to write VBA code using Outlook
Automation or CDO or MAPI.

 

[Jim/Chris]

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

 

[Jim/Chris]

Van is correct.
You can still use the creation of the excel workbook but
you will need to send it with some additional code. Take
a look at this website. I have used this and it works
great.

http://www22.brinkster.com/accessory/modules/005.shtml

Jim