Edit format of Sheet attached in Outlook

Hello:

is there a way to edit the format of the DEST sheet in the code below? I am trying to add pictures, borders, change colors or text etc but I am not sure how to do it since the DEST sheet is never visible and is automatically attached to outlook. Any help would be greatly appreciated as I have been unable to solve this for a few hours. THanks :

Please Login or Register  to view this content.

Hi rlsublime

Were I you, I'd place a breakpoint in your code

Please Login or Register  to view this content.

Then end the sub (reset). Now, work with the open DEST sheet...record macros that do as you wish...get them working as you wish...then copy the code to Note Pad. Now, transfer your recorded code into these lines

Please Login or Register  to view this content.

Hi rlsublime

It'll probably something along these lines of code

Please Login or Register  to view this content.

Where "Transfer" is your sheet name, "Picture 2" is your picture and "A1" is the range you wish to copy to.

Hi rlsublime
Glad to be of help...if that resolves your issue please mark your Thread as solved.