Macro to CopyPaste a Screenshot to Outlook with Recipient and Subject Lines as Cell Ref.

**jtal** · 09-04-2015, 10:29 AM

Hi,

I would like to create a macro that will screenshot cell range "A1:I57" (i57, not A157) and send it to Outlook with the recipient as the email address that is referenced in cell C10 and the subject line as it appears in the following concatenate: concatenate(C8," Quote No. ",C5).

Spreadsheet Specs.
- I am using Office 2013.
- There will always only be one email address in cell C10.
- The data range A1:I57 contains a text box that must be captured in the screenshot.

Any help would be greatly appreciated.

Thanks,
JT

**jtal** · 09-14-2015, 01:11 PM

Does anyone have any insight?

**jtal** · 09-14-2015, 01:14 PM

Does anyone have any insight? I have attached the file.

Macro to CopyPaste a Screenshot to Outlook with Recipient and Subject Lines as Cell Ref.

LinkBack

Thread Tools

Rate This Thread

Display

Macro to CopyPaste a Screenshot to Outlook with Recipient and Subject Lines as Cell Ref.

Re: Macro to CopyPaste a Screenshot to Outlook with Recipient and Subject Lines as Cell Re

Re: Macro to CopyPaste a Screenshot to Outlook with Recipient and Subject Lines as Cell Re

Thread Information

Users Browsing this Thread

Similar Threads

Macro needed: Capture Screenshot and email using Outlook

Macro code to populate outlook email subject line with corresponding cell row

Macro to take a screenshot and bundle into body of Outlook

Export outlook email with subject line to Excel - need to modify to add required lines

Sending the Excel file to multiple recipient in outlook application by using macro

[SOLVED] VBA to open a new email, (outlook) add the recipient, and the subject of 'Issue Found'

[SOLVED] Create an e-mail with recipient, subject and text

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions