Digital Developer Conference: a FREE half-day online conference focused on AI & Cloud – North America: Nov 2 – India: Nov 9 – Europe: Nov 14 – Asia Nov 23 Register now

Close outline
  • United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.195

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

Excel to Lotus Notes Email via VBA image not working

550003FBKE gravatar image
Question by Allan_Sull  (1) | Jun 17 at 04:22 AM emailnotesexcel

I've been using Notes 9 with Windows 7 and Office 2013 to paste an Excel range into the email body of a notes message as a JPEG image,

Since upgrading to Windows 10 with Office 2016 (still on Notes 9) this no longer works as intended. The image pasted into the email body is now blank.

         If Copy_and_Paste Then
             embedCells.CopyPicture xlBitmap
             .Paste
             Application.CutCopyMode = False
         Else
             Save_Object_As_JPG embedCells, tempCellsJPG
             .Import "JPEG Image", tempCellsJPG
             Kill tempCellsJPG
         End If

 Private Sub Save_Object_As_JPG(saveObject As Object, JPGfileName As String)
 
     'Save a picture of an object as a JPG/JPEG file
     
     'Arguments
     'saveObject     - any object in the CopyPicture method's 'Applies To' list, for example a Range or Shape
     'JPGfileName    - the file name (including folder path if required) to save the picture as
     
     Dim temporaryChart As ChartObject
      
     Application.ScreenUpdating = False
     
     saveObject.CopyPicture xlScreen, xlPicture
     
     Set temporaryChart = ActiveSheet.ChartObjects.Add(0, 0, saveObject.Width, saveObject.Height)
     With temporaryChart
         .Border.LineStyle = xlLineStyleNone      'No border
         .Chart.Paste
         .Chart.Export JPGfileName
         .Delete
     End With
     
     Application.ScreenUpdating = True
     
     Set temporaryChart = Nothing
     
 End Sub

People who like this

  0
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

0 answers

  • Sort: 

Follow this question

173 people are following this question.

Answers

Answers & comments

Related questions

Excel to Lotus Notes via VBA image no longer working 2 Answers

Excel to Notes via VBA image not working 2 Answers

email from Outlook / Exchange garbled on receipt 3 Answers

Excel\VBA - Print/Save IBM Lotus Notes Email as PDF before sending NOT supported by Lotus Notes API 0 Answers

Since upgrading to Notes 10, user "Junk Mail Lists" have stopped working 1 Answer

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • Data and AI
  • DataPower
  • Decision Optimization
  • DevOps Build
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • Hyper Protect
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PartnerWorld Developer Support
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges