Re: Access 2003 and Emailing via Outlook

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

From: Scott (sbailey_at_mileslumber.com)
Date: 02/16/04 

Date: Mon, 16 Feb 2004 16:34:22 -0600

I tried below, but it still hangs in outbox. Do you have any ideas on a fix?

DoCmd.SendObject acSendTable, "Employees", acFormatRTF, myemail@myemail.com,
, , "Test Access", "test", False

""Yuan Shao"" <v-yshao@online.microsoft.com> wrote in message
news:CxuHExI9DHA.2164@cpmsftngxa07.phx.gbl...
> Hi Scott,
>
> Thanks for your post. If I understand correctly that you are unable to
send
> the mail automatically via the following codes.
>
> DoCmd.SendObject acSendReport, , acFormatRTF, response
>
> Based on my research, please try to explicitly set the value of
EditMessage
> parameter of the SendObject method to False to send the message without
> edition.
>
> EditMessage parameter
> Optional Variant. Use True (-1) to open the electronic mail application
> immediately with the message loaded, so the message can be edited. Use
> False (0) to send the message without editing it. If you leave this
> argument blank, the default (True) is assumed.
>
> For more information on SendObject method, please refer to the following
> article:
> SendObject Method
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm
> l/acmthactSendObject.asp
>
> For example in the northwind.mdb sample database:
>
> DoCmd.SendObject acSendReport, "Employees", , "<mail address>", , , _
> "Current Spreadsheet of Employees", , False
>
> It works on my side in Access 2003 with Outlook 2003. Please check to see
> if it meets your requirements.
>
>
> Thanks for posting in community.
>
> Regards,
>
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
>

Relevant Pages

  • Re: Access 2003 and Emailing via Outlook
    ... have to go to Outlook and press Send. ... >> DoCmd.SendObject acSendReport,, acFormatRTF, response ... >> parameter of the SendObject method to False to send ... >> EditMessage parameter ...
    (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: Error emailing Excel attachment
    ... On Jul 20, 9:52 am, Stephanie ... When send an email with at RTF attachment, ... DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName,, ...
    (microsoft.public.access.formscoding)
  • 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)