1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel Vb to send mail using outlook express

Discussion in 'Internet Explorer & Microsoft Edge' started by PeterFerreira, 2005/07/21.

Thread Status:
Not open for further replies.
  1. 2005/07/21
    PeterFerreira

    PeterFerreira Inactive Thread Starter

    Joined:
    2005/07/21
    Messages:
    2
    Likes Received:
    0
    Runtime Error '429' when using vb code to send mail via Outlook Express

    I wrote a program using VB in excel 2003. The user fills in the form and clicks a button. The button saves the excel workbook and then sends it as an attachment to my mailbox. I have had many successful users who have Outlook, however I have come across a user who is using Outlook Express and when she pressess the send button it asks her to debug. Is there different coding or an option in Outlook Express which will allow her to send via email?

    The error she gets is:
    Runtime Error '429': ActiveX Component Can't Create Object

    I think the user needs to download Microsoft Scripting Engine, however I want to be sure that is the solution and it isn't a compatability problem with Outlook Express.

    Here is my sendmail code:
    ActiveWorkbook.SendMail "email address ", "Profile "

    *Note: I put "email address" for security purposes. Real email address in actual program.
     
  2. 2005/07/21
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389

  3. to hide this advert.

  4. 2005/07/22
    PeterFerreira

    PeterFerreira Inactive Thread Starter

    Joined:
    2005/07/21
    Messages:
    2
    Likes Received:
    0
    I am using an excel form to send the workbook via email. Everything works fine with Outlool, however when a user has Outlook Express, they get a Runtim error 429. I had them download the MS Scripting Engine, this did not solve the problem. Does Outlook Express support vb automatically sending an email? Here is the code I am using:

    ActiveWorkbook.SendMail Recipients:= "email address not shown for security ", Subject:= "Profile "

    Please help.

    Can't figure this out.
     
  5. 2005/07/22
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Please do not start a new thread on the same subject - I have merged your threads.
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.