+ Reply to Thread
Results 1 to 2 of 2

[VBA] Save Range as picture, save to file, attach to email

  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    [VBA] Save Range as picture, save to file, attach to email

    Hi,

    I am running into troubles with the following code when executing it in Excel 2016. The purpose of this code is to save a range of cells as a picture, save this picture on the desktop and then create an email with the file as an attachment. The problem only appears in Office 2016 but works fine in 2013.

    Any help would be appreciated.


    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Re: [VBA] Save Range as picture, save to file, attach to email

    What's the problem?
    Design everything to be as simple as possible, but no simpler.

+ 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. VBA to save a sheet as a PDF and then attach to an email. Almost there.
    By AZZ70 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2015, 03:13 PM
  2. VBA to save one sheet as PDF and attach it to an email
    By KT999 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2014, 03:35 PM
  3. I need VBA to save file and attach file to email based on conditional statements
    By jcrowe31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 09:41 AM
  4. Macro to save and attach spreadsheet to email template?
    By lpearson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2013, 05:36 PM
  5. [SOLVED] Save selected range in a pdf format & email the file to a someone automatically?
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2013, 12:16 PM
  6. Excel 2010 ActiveSheet save as PDF and attach to Email
    By xmachinex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2012, 07:38 AM
  7. Convert to PDF, Save to Network Drive, AND/OR attach PDF to an email (Automatically)
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2011, 12:42 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