Help with SendObject

[Jackie]

When the following line of code is executed I get the "outputting to mail message" window displayed, but then Access crashes:

(The LOTUS VIM Mail Support option is unchecked under Office Tools.)

DoCmd.SendObject acSendReport, "PM_Proj_Num", "RichTextFormat(*.rtf)", "userabc", "", "", "PM report", "Attached is the weekly PM STatus Report", False

This is the error message:

MSAccess Window "This program has performed an illegal operation and will be shut down".

Details include:
MSACCESS caused an invalid page fault in
module <unknown> at 0000:a0000001.
Registers:
EAX=00c6003c CS=016f EIP=a0000001 EFLGS=00010246
EBX=03006f1c SS=0177 ESP=0062e598 EBP=0062e5c8
ECX=0062e5c4 DS=0177 ESI=00000920 FS=107f
EDX=033ff010 ES=0177 EDI=00c67860 GS=0000
Bytes at CS:EIP:

Stack dump:
3018a409 00c67860 3018a438 0062e5c4 300fc368 651a1000 00c67d48 033ff010 030ff00c 033ff00c 3014822f 00000920 0062e5e0 300c7688 0062e624 00000000


Any help would be appreciated.

 

[Junior1544]

My proposed solution. don't use sendobject...

Are you using outlook or lotus notes?? Using either one of those programs a procedure can be written (or gotten from the faq's here) that will control the acual program and send it that way...

I think it's a much more stable way of doing things...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Jackie]

I am using Outlook. Do you have a specific thread number/FAQ that references the SendObject method?

 

[Junior1544]

here is some place for you to start...

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=1634&CFID=84596856&CFTOKEN=64117292

if you need some specific code, i'd be happy to help... i have some thing i use, but i would need to dig it up...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.