+ Reply to Thread
Results 1 to 11 of 11

Email will not automatically send

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Email will not automatically send

    I am trying to set up a inventory list, in excel 2007. to email me when items get to a certain threshold and when I enter the macro to email me an alert, it will not send. The macro is working because when I change .Send to .Display, my email pops up. Any help would be greatly appreciated... if you need a copy of the spreadsheet, let me know. Thank you

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Email will not automatically send

    Did you check your security setting of OUTLOOK, check if "access programitacally to use outlook" is checked..
    or check you outbox also..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Email will not automatically send

    Thanks. I don't have admin access to a lot of my security settings but in my "trust center" everything looks like it will not stop me from sending out the emails. Plus, if the macro works to generate the email when I use the .Display function, wouldn't that still tell me that outlook is willing(able) to work with excel? Just asking.

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    7,998

    Re: Email will not automatically send

    Hi, cgduck21,

    just an idea: please check the email address (maybe mistyped) or try adding the address to the contact list before trying to send.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  5. #5
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Email will not automatically send

    I tried the .display and then sent the generated email with success. When I run the macro with .send, nothing happens. Here is the file in question.

    MAA Inventory.xlsm

  6. #6
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Email will not automatically send

    It worked fine for me first time. Did you check your "all mail" folder in gmail? Could the automation cause gmail to filter it out?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  7. #7
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Email will not automatically send

    No joy. It is like excel is toying with me... it tells me everything is fine and I run in .display and everything is good and then I use .send and excel becomes this monster that doesn't want to waste it's precious time with this stupid user... he will never be good enough for us! Let us toy with him!

  8. #8
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Email will not automatically send

    Is there a setting that the admin has control over that would allow the email to work in .display but not with .send? I'm just boggled!

  9. #9
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Email will not automatically send

    cgduck21,

    Check your inbox for my test email.

  10. #10
    Registered User
    Join Date
    07-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Email will not automatically send

    Rgr- I replied, which is why the issue MUST be in the admin settings of my outlook.

  11. #11
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Email will not automatically send

    try something like this...
    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)

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