+ Reply to Thread
Results 1 to 2 of 2

Outlook - format screengrab which has been pasted in email

  1. #1
    Forum Contributor
    Join Date
    07-24-2008
    Location
    Athome
    MS-Off Ver
    Excel 2013
    Posts
    127

    Outlook - format screengrab which has been pasted in email

    Hi guys. Killing myself trying to figure this out. I usually do a bit of amateur VBA in Excel and most of the time I can get it right (lifting code from the forums + using macro recorder, and adapting to make it work).

    For outlook, I often paste screen captures in email. I like to format the screen captured picture as follows -
    size 60% height and width
    line color - blue and 2pts width

    Can anybody please help me with a macro that will do this? The picture is pasted in email, click on the picture to select it. Now need to press macro button (I will insert on the QAT, Excel 2013).


  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Outlook - format screengrab which has been pasted in email

    You will have to use the WordEditor like this: http://www.slipstick.com/developer/w...outlook-email/ The sample code works on a selection and it shows how to use .Color = wdColorBlue

    Your picture will likely be an InlineShape. This shows how to use .ScaleHeight http://forums.slipstick.com/threads/...ment-resizing/

    This shows how to use Line.Weight http://windowssecrets.com/forums/sho...ord-(VBA-Word)
    To mark "Solved" go to Thread Tools.

+ 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. Replies: 2
    Last Post: 10-02-2014, 04:29 PM
  2. [SOLVED] ***Wrong sheet gets pasted in the outlook mail***
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2014, 11:55 AM
  3. [SOLVED] Using Exell VBA to launch Outlook Email while separating lines in the body of Outlook.
    By Tazyote in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-27-2013, 01:18 PM
  4. Macro to send saved draft email from outlook in HTML format
    By jamesshakedown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2013, 07:55 AM
  5. Outlook email from Excel VBA - message format & importance
    By ssu95bm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2012, 10:32 AM
  6. Using Excel 2007 to Prepare an Email in Outlook 2007 in a customized format.
    By rahulin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2010, 08:36 AM
  7. Excel WorkSheet Pasted Into Outlook
    By dthhal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2009, 11:44 AM

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