Sending multiple queries in an e-mail

[Keith Thompson]

How do I send mulitple queries in one SendObject command.
I have built a macro by using the SendObject action. But
I'm limited to only one output spreadsheet. I would like
it to attach two spreadsheets. I tried to use two
SendObject actions in a row but this will not work because
of the action argument.
Any help would be greatly appreciated!
-Keith

 

[Steve Schapel]

Keith,

I am not sure why two consecutive SendObject actions would not work. I
would expect this to be ok. The only other solution I can think of is
to use an OutputTo action to save one of the spreadsheet files, then an
OutputTo action for the other one, with the Edit Message argument set to
Yes, and when the email opens in your email client (with the second
spreadsheet file already attached), manually attach the first
spreadsheet file before sending.

 

[Steve]

Steve,
Thank you for the suggestion. What I'm trying to avoid is
to have to save the file and attach just because we output
about 50 of these a day. When I do use two consecutive
SendObject actions it will attach the first one. But I
have to send it or close it and then the second one will
open up as a seperate e-mail. Since we are going to be
sending this to muliple users on different accounts I was
trying to avoid two e-mails per account. This could get
overwhelming. I think I'm going to have to write it in VB
(which I don't know). That's the only way it looks like it
could be done.
Thank you for your help on this. I appreciate it!

 

[Steve Schapel]

Keith,

Yes, I agree this is beyond the scope of what is convenient for the
SendObject macro. Although if you don't want to edit the email as it
"passes through", it could possibly be made workable.

"Write it in VB" is not straightforward. You may want to consider Total
Access Emailer from www.fmsinc.com which I use myself and find excellent.

There is also some good information that might help you at
http://www.granite.ab.ca/access/email.htm