Error emailing Excel attachment

  • Thread starter Thread starter Guest
  • Start date Start date
G

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....
 
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....
Click to expand...

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