Take Screenshot and add to email

Help
1

Hi,

I need to do the following:

  1. Open Excel

  2. Take Screenshot of Pivot table

  3. Attach the image to an email

  4. Send the Email.

Thanks,
Shawn

1 Like
2

@shawnmurray

  1. Use Excel application scope
  2. Read range activity of required sheet
  3. Use Screenshot activity and save the file as some path and save the path in variable
  4. Use send email activity and in the attachments give the same path

Hope this helps

1 Like
3

Fine
hope these steps could help you resolve this
–Use start process and pass the file path of excel as input
–this will open the excel and get that to foreground
–to make sure that the excel screen is full to window size use a maximize window activity and this will get the excel to full screen
–now use a Take screenshot activity which will save the image of the foreground screen to a .png file

–now use save image activity where pass the input with file path where we want to save the file and mention the image variable that we obtained from the take screenshot, as input

–now use send outlook mail activity or any send mail activity where in the attach file property in the activity mention the file path of the image that we saved previously

simple isnt it
hope this would help you
kindly try this and let know for any queries or clarification

Cheers @shawnmurray

4 Likes
4

Hi @Palaniyappan
Is there a way that i can get it to open on the worksheet i want or will i have to manually select it before using “Take Screenshot” activity

Cheers

5

yah it can be done either manually with click activity or send hot key activity
or we can use macro to execute them

Cheers @shawnmurray

1 Like
6

The sheet may not always be in the same place so a click activity wouldnt work…

How would i use the send hotkey to select a sheet?

cheers @Palaniyappan

7

@shawnmurray - “Select Range” activity has SheetName as an Input you can pass

1 Like
8

When i have taken the screenshot, how do i save it?

cheers @HareeshMR

9

We have save image activity available to save the image @shawnmurray :slight_smile:

1 Like
10

Perfect

image
What do i input for image field?

Thanks @HareeshMR

11

The output of the take screenshot activity @shawnmurray :slight_smile:

image

1 Like
12

Okay thanks i will test! @HareeshMR :slight_smile:

13

@shawnmurray,

Sure :slight_smile:. Do let me know if that helps

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.