+ Reply to Thread
Results 1 to 3 of 3

VBA to create and send emails with attachments 2019 ok/2016 not ok!

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    Plymouth, UK
    MS-Off Ver
    2019,2016
    Posts
    2

    VBA to create and send emails with attachments 2019 ok/2016 not ok!

    Hi all,

    The code below works fine in 2019 but throws up loads of errors in 2016 starting at the .To lines (mainly application defined or object defined). Any help in adjusting to work on 2016 would be an absolute life saver!

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 02-27-2020 at 10:03 AM. Reason: Code tags as usual

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,732

    Re: VBA to create and send emails with attachments 2019 ok/2016 not ok!

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then 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

    I did it for you this time. Please read forum rules. Thanks

  3. #3
    Registered User
    Join Date
    02-27-2020
    Location
    Plymouth, UK
    MS-Off Ver
    2019,2016
    Posts
    2

    Re: VBA to create and send emails with attachments 2019 ok/2016 not ok!

    Apologies, and thank you.

+ 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. Macro to send emails with attachments and signature
    By coolx72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2019, 11:23 AM
  2. Send multiple emails with different attachments if attachments found
    By AnkitJain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 05:35 AM
  3. Macro to send automatically emails to different people with attachments
    By Dr.Tenma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2015, 08:38 AM
  4. Send personalized mass emails with multiple attachments
    By land_land in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2014, 01:45 AM
  5. [SOLVED] VBA to send emails with different attachments to each seperate email
    By gillyr7 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-14-2014, 02:25 PM
  6. VBA to send multiple emails with different attachments
    By gillyr7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2014, 02:33 PM
  7. [SOLVED] Need Macro that will create & send emails w/ attachments from a list in Excel
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2012, 07:02 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