Sending screenshot via outlook using excel code

**ge0rge** · 10-23-2008, 09:53 AM

I am in need of some way to capture a screen shot of a program on screen and send it to a specified email address at a certain time of the day. I would not think its impossible, could it be done using vba code?

**arthurbr** · 10-23-2008, 09:57 AM

I am in need of some way to capture a screen shot of a program on screen

Is it an xl screenshot?

**ge0rge** · 10-23-2008, 10:58 AM

It would be of another program open on the desktop. I am also thinking it may be easier to have it save the screenshot to a folder instead of emailing it.

**Leith Ross** · 10-23-2008, 11:16 AM

Hello ge0rge,

It is doable. I will be out of my office for a while, but will dig the code up when I get back.

Sincerely,
Leith Ross

**ge0rge** · 10-23-2008, 11:28 AM

That would be great. In the meantime I am going to give it a go.

**Leith Ross** · 10-23-2008, 04:39 PM

Hello ge0rge,

Capturing the screen is the easy part. I am having problems with embedding a picture in Outlook. Not sure if is my email setup or a problem with Outlook. I'll keep you updated.

Macro Code to Capture the Screen

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**ge0rge** · 10-23-2008, 05:39 PM

I have decided to save it to a folder instead if it helps...

**Leith Ross** · 10-23-2008, 08:12 PM

Hello ge0rge,

I may have wasted a lot of your time today. Did you want this picture emabeded in the body of the email or sent as an attachment?

Sincerely,
Leith Ross

**ge0rge** · 10-24-2008, 05:08 AM

You did not waste my time. I generally come here for help after I already spent 1-2 hrs looking for answers throughout the day. The projects I work on never were officially given to me as objectives, but to help our department I am always trying to develop faster, more fool proof ways of doing things. I slowly turned into the guy everyone asks for excel help. The good news is that most don't know what vba code is, so no questions there.

Either way would work just fine. Thanks for helping!

**ge0rge** · 11-21-2008, 10:01 PM

Perhaps there should be an abandoned tag as well as the solved one.

**Leith Ross** · 11-24-2008, 02:38 PM

Hello ge0rge,

Your post isn't abandoned, I am just a little behind. I have been busy this last week and now I'm catching up with posts. Since you have moved the file to a separate folder, the easiest approach would be to send the file as an attachment using Outlook. This macro will prompt you for the file using a file dialog box. The recipient, subject and message are taken from the active worksheet cells A1, B1, and C1 respectively. You can change this to match the cells you are using. They are marked in red.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time.
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

**skultety** · 12-03-2010, 07:35 AM

(deleted)...

**skultety** · 12-06-2010, 10:31 AM

(deleted)...

**huseyinkasirga** · 02-06-2012, 06:16 PM

Hello Leith,

I found you here too

May you remember my problem from another forum. I think I have mistake combining two codes together. Here are two codes I am working on. First one is "ScreenCapture" to copy the active window into clipboard and second one is "emailimage" to paste clipboard to outlook mail. If I run them seperately with two buttons (click first then second), they do what I want. However I cannot combine them to run just with 1 click (I have used Call code, but screencapture is not seems to work properly ). How can I combine them together or run them properly with just 1 click?

1.Code: "Screencapture"

Please Login or Register  to view this content.

2.Code: "emailimage" to paste clipboard into email body

Please Login or Register  to view this content.

3. Runboth:

Please Login or Register  to view this content.

**huseyinkasirga** · 02-07-2012, 04:43 AM

Dear All,

Can anybody help me about the problem mentioned above?

Thanks in advance.

**Domski** · 02-07-2012, 05:23 AM

Please take a moment to read the forum rules.

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Dom