+ Reply to Thread
Results 1 to 2 of 2

Print Screen Error in outlook VBA

  1. #1
    Registered User
    Join Date
    10-15-2018
    Location
    Leeds
    MS-Off Ver
    windows 10
    Posts
    7

    Print Screen Error in outlook VBA

    Hi All

    Well I have decided to build the userform in outlook and just paste it to the outlook email body..

    However, I want to PrintScreen the userform and paste in the outlook email body.

    The code perfectly works fine when I built it in excel vba, but did work in outlook vba.

    There is a problem with using the Application.Sendkeys in outlook. (It gave an error message: Run time error 438. Object doesnt support this property or method



    Can you offer any solution on how to use this command in outlook vba?

    Attached is my code screenshoot
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Print Screen Error in outlook VBA

    hmmmm
    try to avoid using SendKeys if they can, because it has a reputation for unreliability.
    maybe try alternative API solution
    https://wordmvp.com/FAQs/MacrosVBA/PrtSc.htm
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Print screen of the Mainframe Screen
    By smilswathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2014, 05:54 AM
  2. Replies: 10
    Last Post: 04-19-2011, 09:27 PM
  3. Alt+Print Screen then Opens new Outlook Mail Message and Pastes into Body of Email
    By Alex Pipes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2010, 06:53 AM
  4. screen capture, screen print
    By MrsGKL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2010, 11:14 AM
  5. how to capture screen (print screen) in VB
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2010, 02:29 PM
  6. [SOLVED] print box opens in right screen of dual screen setup why
    By gerrys in forum Excel General
    Replies: 1
    Last Post: 06-30-2006, 01:50 PM
  7. [SOLVED] Print and Print Preview don't match screen
    By JNohl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2005, 06:39 PM

Tags for this Thread

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