Results 1 to 2 of 2
  1. #1
    edzigns is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Apr 2011
    Posts
    8

    Auto email not working

    HELP!



    2 things are happening/ not happening

    1st, this same code used to open a new message in Outlook 2010 and populate To, CC, Subject and Body with information from form yesterday, but now receives error:
    Run-time error '229'
    XXXX HelpDesk can't send this email address.

    2nd, it required that I manually click Send on message (when it worked), which I wanted it to automatically do via code...

    DoCmd.SendObject , , acFormatTXT , varTo , varCc , , stSubject,stText , -1

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    First question would be do the variables contain valid email addresses? Change the last argument to 0 for the email to be sent automatically.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 04-13-2011, 10:11 AM
  2. Replies: 1
    Last Post: 03-31-2011, 02:51 AM
  3. Auto email query
    By warrigal in forum Database Design
    Replies: 3
    Last Post: 03-23-2011, 07:09 PM
  4. send email to email addresses in database?
    By cnstarz in forum Access
    Replies: 5
    Last Post: 03-02-2011, 09:46 PM
  5. Email from report to Email body
    By Ehmke66 in forum Programming
    Replies: 4
    Last Post: 01-03-2011, 01:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums