+ Reply to Thread
Results 1 to 10 of 10

Issue send email with excel 2016 true outlook 2016

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    Issue send email with excel 2016 true outlook 2016

    Dear mr / mrs,

    Below VBA work fine on excel 2010 but not working on excel 2016 with outlook 2016
    please help me to resolve this issue
    thank you in advance for your support


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kirana2014; 09-12-2017 at 11:34 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Issue send email with excel 2016 true outlook 2016

    I'ved tested your code on both Excel versions (2010 & 2016) and they both work.
    Can you be more specific on how it doesn't work in Excel v2016 & Outlook v2016

  3. #3
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    Re: Issue send email with excel 2016 true outlook 2016

    can be because I use windows 10 ?

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

    Re: Issue send email with excel 2016 true outlook 2016

    Works fine for me on Office 365 on Win10Home. I added .Display after the commented .Send line to see that it "works".

    What does "not work" mean for you?
    Last edited by Kenneth Hobson; 09-11-2017 at 01:30 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Issue send email with excel 2016 true outlook 2016

    kirana2014, Nope. I'm running Windows v10 with Office 2010 and it's working for me. As well as my other machine which I am running Windows v7 with Office 2016

  6. #6
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    Re: Issue send email with excel 2016 true outlook 2016

    When I check on " Sent items on outlook is nothing and my colleague not receive email from me !

  7. #7
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Issue send email with excel 2016 true outlook 2016

    in your code you have it set to .Display. just curious, did you change it to .Send?

  8. #8
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    Re: Issue send email with excel 2016 true outlook 2016

    Yes I change it to .send
    on .display i can't see them on outlook (very strange)

    Checkmark on Tools>References in the Menu bar

    visual Basic for applications
    Microsoft excel 16.0 object library
    Ole automation
    Microsoft office 16.0 object library

  9. #9
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Issue send email with excel 2016 true outlook 2016

    I (only) have all four of those checked as well, and still I'm having a difficult time trying to duplicate your error.
    I've tested the sending the email from Outlook 2010 to Outlook 2016 and vice-versa and received no issues as you described.

  10. #10
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    Re: Issue send email with excel 2016 true outlook 2016

    There all thank you for support, I just found the problem on my office , I made wrong Path Attachment (folder) on C

+ 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] Excel 2016 issue with ExecuteExcel4Macro?
    By kuno in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2017, 09:29 AM
  2. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  3. VBA Send email from outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2017, 01:29 PM
  4. Using VBA on Excel workbook to set up reminder via Outlook (Office 2016)
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2017, 12:13 AM
  5. Copy /paste excel data with mouse over comments to outlook 2016.
    By Rakeshkrishnan01 in forum Excel General
    Replies: 3
    Last Post: 06-28-2017, 02:24 PM
  6. VBA auto outlook 2016 to send e-mail based off criteria
    By broman5000 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-30-2017, 04:15 PM
  7. Replies: 2
    Last Post: 05-24-2016, 10:43 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