Re: Error emailing Excel attachment

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Jul 20, 9:52 am, Stephanie <Stepha...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
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.

.

Relevant Pages

  • Re: Access 2003 and Emailing via Outlook
    ... DoCmd.SendObject acSendTable, "Employees", acFormatRTF, myemail@myemail.com, ... > DoCmd.SendObject acSendReport,, acFormatRTF, response ... > EditMessage parameter ... > For more information on SendObject method, ...
    (microsoft.public.access.formscoding)
  • Re: DoCmd.OutputTo
    ... To send a report, use this command: ... DoCmd.SendObject acSendReport, strReportname, acFormatRTF, strRecipient, ... The string variables can be populated however you want, either from the db, ...
    (microsoft.public.access.modulesdaovba)
  • Re: E-Mail Problem
    ... A2000, Win98, Opera 7.23, ... DoCmd.SendObject acSendReport, rpt, acFormatRTF, adresse ... Gruss ...
    (microsoft.public.de.access)
  • Re: date in subjectline for automated email
    ... Parasyke wrote: ... DoCmd.SendObject acSendReport, "This Is My Subject Line", acFormatRTF, ... (if you're like MLH, it's carefully hidden ...
    (comp.databases.ms-access)