[AccessD] SendObject

It is probably getting confused on the recipient email address
you could try sticking a comma to seperate the two email addresses
or drop the second email address.
You could open up the second database via something like TsiSoon
and use this command or run the report to create a file and then
use OLE automation with Outlook to send the file as an attachment.

http://www.peterssoftware.com/c_emfa.htm

limits of sendobject faq
http://www.granite.ab.ca/access/email/sendobject.htm

http://www.granite.ab.ca/access/email/

TSISoon
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8


Rocky Smolin - Beach Access Software wrote:

>Dear List:
>
>Client has 2 question2:
>
>1)  why doesn't this format work for him:
>
>DoCmd.SendObject acSendReport, "rptUDStatus-Service-11", acFormatRTF, 
>"james at Charltonweeks.com <mailto:james at Charltonweeks.com>", , , 
>"Status", "Here is the status of your eviction.", False
>
>and  2) can he point to an object to send which is in another database?  
>In this case of the report "rptUDStatus-Service-11" is in another mdb?
>
>MTIA
>
>Rocky
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada