Sending multiple queries in an e-mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keith Thompson - 23 Jul 2004 21:32 GMT

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

Reply to this Message

Steve Schapel - 23 Jul 2004 22:13 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> How do I send mulitple queries in one SendObject command.
> I have built a macro by using the SendObject action. But
[quoted text clipped - 4 lines]
> Any help would be greatly appreciated!
> -Keith

Reply to this Message

Steve - 23 Jul 2004 22:59 GMT

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!

>-----Original Message-----
>Keith,
[quoted text clipped - 16 lines]
>> -Keith
>.

Reply to this Message

Steve Schapel - 23 Jul 2004 23:22 GMT

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

Signature

Steve Schapel, Microsoft Access MVP

> Steve,
> Thank you for the suggestion. What I'm trying to avoid is
[quoted text clipped - 9 lines]
> could be done.
> Thank you for your help on this. I appreciate it!

Reply to this Message