+ Reply to Thread
Results 1 to 2 of 2

How to Send Email Reminders Automatically from Excel Worksheet Using VBA

  1. #1
    Guest
    Join Date
    05-11-2016
    Location
    Washington, DC
    MS-Off Ver
    Microsoft Office 2016 Tools
    Posts
    0

    Question How to Send Email Reminders Automatically from Excel Worksheet Using VBA

    Hello Everyone! I'm somewhat new to VBA. I've gone over my Excel spreadsheet code several times and I keep getting an error (highlighted in yellow) message in “Module1” at the following line of code: Set OutLookApp = CreateObject("OutLook.Application"). Here’s the actual error message: “Run-time error ‘429’: ActiveX component can’t create object” Any answers as to why this is happening? Any help on this will be greatly appreciated.
    Last edited by TTDent; 05-11-2016 at 01:26 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello TTDent,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Can I automatically send a monthly email with Excel VBA?
    By slobdiddy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2016, 12:31 AM
  2. Macro to send worksheet via email automatically and find text instead of numbers
    By parrisD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-31-2015, 11:48 AM
  3. Have excel automatically send an email when a date is near
    By MCCranes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2014, 09:16 AM
  4. Macro to send automated email reminders
    By Amber12 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-13-2014, 11:22 AM
  5. Need help with getting excel to automatically send out email....
    By glynjara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 06:57 PM
  6. Need Excel to send Automatically an Email
    By japorms in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-20-2011, 02:57 AM
  7. Replies: 0
    Last Post: 03-23-2005, 01:06 PM

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