Results 1 to 2 of 2
  1. #1
    Eef is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2014
    Posts
    11

    Sending Email 2295 errormessage

    I want to sent an Email to all members with:

    DoCmd.SendObject acSendNoObject, , , _
    xEmail, , , _
    "my Text", xText, False


    I collect all individual emailadresses into 1 string called xEmail (with ; as separator). I have about 250 emailadresses. Result is a len(xEmail) ~ 5700 characters.
    For every email sent a receive a message from MS Outlook asking me if sending an email is allowed (after 5 sec waiting). I allow the sending and that moment MS VBA reports a 2295 error window.

    Translated from Dutch:
    Error 2295 during execution (Fout 2295 tijdens uitvoering):


    Name of addressee(s) unkown. Message not sent (De naam van de geadresseerde(n) is onbekend. Het bericht wordt niet verzonden.


    I tried to split the action in more than 1 DoCmd. Outlook accepts the emails with less characters in xEmail. They are in my outbox of Outlook. But the action always ends in 2295.

    It seems to me that somewhere between the VBA-code and MS Outlook all emailadresses are accumulated up to a certain #characters (~ 3750 characters in xEmail?).
    When debugging my code xEmail has correct values.

    Has anyone seen this before and a solution for me? I searched for a solution. It's a known problem, but without a solution......

  2. #2
    Eef is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2014
    Posts
    11
    PROBLEM SOLVED!!!!

    Error occurs when one or more emailaddresses are invalid.
    e.g. space character, no countrycode in domain

    I discovered 3 of them in my database.

    Eef

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

Similar Threads

  1. Sending a Report by Email
    By Robert2150 in forum Programming
    Replies: 3
    Last Post: 10-25-2014, 11:14 PM
  2. sending email from outlook
    By darwish in forum Programming
    Replies: 1
    Last Post: 04-16-2014, 07:49 AM
  3. Sending A Report Via Email
    By Ka-Tet in forum Reports
    Replies: 0
    Last Post: 09-02-2013, 09:18 AM
  4. Email sending
    By Steven.Allman in forum Access
    Replies: 25
    Last Post: 06-21-2010, 09:37 AM
  5. Sending email
    By nashr1928 in forum Reports
    Replies: 8
    Last Post: 04-27-2010, 11:14 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