Error emailing Excel attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephanie - 20 Jul 2007 15:52 GMT

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....

Reply to this Message

OldPro - 20 Jul 2007 20:13 GMT

> I thought I had posted this, but can't see it...
>
[quoted text clipped - 10 lines]
> 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.

Reply to this Message

Stephanie - 20 Jul 2007 20:50 GMT

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

> > I thought I had posted this, but can't see it...
> >
[quoted text clipped - 13 lines]
> 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.

Reply to this Message