Results 1 to 2 of 2

Thread: Macro needed to copy rows from spreadsheet to email as image (not as attachment)

  1. #1

    Macro needed to copy rows from spreadsheet to email as image (not as attachment)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,
    I am pretty new to all this so please bear with me.

    I have a pretty simple excel spreadsheet which consists of 9 columns. One of these columns is a check box. I would like a macro that, when that check box is ticked, I can press a button on the sheet and all the rows where the checkbox is ticked (but only data in columns B to I) are copied as an image and pasted into a new email message, not as an attachment to that email but as an image displayed in the email body. I do hope you can help.

    Many thanks

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    There are two types of checkbox, if you right-click one type it will have 'Assign macro' included in the context menu, the other type won't. Which type are yours?
    Also, what email application are you using?
    And if you could link to a small workbook somewhere in the cloud that would save us trying to reproduce your layout and guessing wrongly, especially about how a checkbox islonked to a row (besides position), that would help.
    Last edited by p45cal; 2015-10-03 at 10:27 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •