+ Reply to Thread
Results 1 to 2 of 2

Sending email using CDO

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Sending email using CDO

    Hi,

    I'm trying to send a basic email using CDO following Ron de Bruin's example http://www.rondebruin.nl/win/s1/cdo.htm but just cannot get it to work and can't see where on earth I'm going wrong.

    Here's my code and the error I get is "Run-time error '-2147220978 (8004020e)': The server rejected the sender address. The server response was: 530 5.7.1 Client was not authenticated."

    Please Login or Register  to view this content.
    I found my smtp server by looking in Outlook properties so I know that's right and for all instances of "[email protected]" I am putting my email address and the password is the normal password I use to log on.

    Any help would be greatly appreciated. Feel like I'm banging my head against a wall with this one!

    Sarah

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Sending email using CDO

    This is what I use for gmail.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. automation/macro for sending email to multiple email address
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2013, 12:13 PM
  2. Sending HTML email via excel VBA - arriving as RTF email
    By Shuter1 in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2012, 04:35 AM
  3. Sending Email Dependent on Default Email Client
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2010, 06:51 AM
  4. Sending an email from Excel to multiple email addresses
    By insanity66 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2009, 02:01 PM
  5. Sending email using users preferred email client
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2009, 06:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1