Error emailing Excel attachment

[Guest]

I thought I had posted this, but can't see it...

When send an email with at RTF attachment, all is well.
DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName, ,
, "Member List", "Attached is an updated Member List"

However, when I try to send an email with XLS attachment I see error #2498
an expression you entered is the wrong datatype for one of the arguments.
DoCmd.SendObject acSendReport, "Member List", acFormatXLS, Me.EmailName, ,
, "Member List", "Attached is an updated Member List".

Yesterday, when I left off the argument acFormatXXX, the email would ask me
what type of attachment I wanted to send. I'm not sure what is different
today, but if I leave off this argument, I get the error #2498 as well....

 

[OldPro]

I thought I had posted this, but can't see it...

When send an email with at RTF attachment, all is well.
DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName, ,
, "Member List", "Attached is an updated Member List"

However, when I try to send an email with XLS attachment I see error #2498
an expression you entered is the wrong datatype for one of the arguments.
DoCmd.SendObject acSendReport, "Member List", acFormatXLS, Me.EmailName, ,
, "Member List", "Attached is an updated Member List".

Yesterday, when I left off the argument acFormatXXX, the email would ask me
what type of attachment I wanted to send. I'm not sure what is different
today, but if I leave off this argument, I get the error #2498 as well....

Is your email program MAPI compatible? It needs to be. Also, are you
using Access 2000? It has a known problem with SendObject and Excel.

 

[Guest]

Thanks for the reply. I am using Outlook as the email program and Access 2002.