+ Reply to Thread
Results 1 to 6 of 6

help with sending email from Excel via Web Outlook (OWA)

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    help with sending email from Excel via Web Outlook (OWA)

    Hi all

    I have the following code in my Excel worksheet. This code successfully send out email to our customers when if the criteria is true. I have tested this at home and it works perfectly as I use Outlook at home. However when I take this code to work I couldn't get this working as at work we use Outlook 365 and we use web Outlook, OWA.

    is there a setting I can specify to use OWA as I don't think I am allowed to install outlook at work. I need this help urgently as I have to present this code to my boss.

    Any help is much appreciate it.

    Please Login or Register  to view this content.
    Last edited by rv02; 06-24-2014 at 05:14 AM. Reason: comply with rule 3

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: help with sending email from Excel via Web Outlook (OWA)

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Re: help with sending email from Excel via Web Outlook (OWA)

    Sorry about this. I have now amended the formatting and hopefully will get a reply soon as I really need this urgently and am completely new to VBA

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: help with sending email from Excel via Web Outlook (OWA)

    No, not in this way, you will need entirely different code. Have a look at CDO http://www.rondebruin.nl/win/s1/cdo.htm

  5. #5
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Re: help with sending email from Excel via Web Outlook (OWA)

    is there anyway that someone can help me to rewrite the code I included or do I need to go to the commercial site for this to happen as I am new to VBA and not sure how t do this. The main body if the program works its only th e email bit I need changed

    I would really appreciate any help

  6. #6
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    Re: help with sending email from Excel via Web Outlook (OWA)

    I tried the example and it works but when I try to do this with my work email it sends the server could not authenticate. At work we are using Office365, and I think the smtp server is smtp.office365.com but I cant not get it working. do I have to be running this when I am in the office or can I try it from home. the gmail example worked fine but the office 365 does not run

+ 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. [SOLVED] sending email from outlook using vba excel
    By joshshaji in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-31-2012, 08:27 PM
  2. VBA coding for sending email from excel with the help of outlook
    By NASIR KHAN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2012, 07:17 PM
  3. Need help!! Sending email from outlook through excel
    By tuyash in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2011, 06:04 AM
  4. Sending email addresses in excel via outlook
    By dwarford101 in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 07:51 AM
  5. sending email with Outlook using Excel
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2006, 02:45 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