Hello All-
I really beg that you can help me. I'm not even sure if this is possible but I would love any help I can get!
Problem:
I receive an email report every morning around 2am with a subject and attachment name: Date 2014 Report Name.xlsx
I'm responsible for waking up early, opening the report, selecting four specific ranges (does not change) and emailing them to four specific people (either pasting it or screenshot).
If this does not get done by 6am I get yelled at and stuff hits the fan.
Hopeful Solution:
Would love to automate the process. If not completely at least partially.
1) Outlook rule/script to look out for the email and then perform action
2) Automatically select specific section of a sheet (ie/ Sheet 'Data'! - Range A7:F10) & either save as PDF or as a seperate xlsx or just copy it.
3) Email #2 to a specific user.
#2 & #3 would be run 4 times total, 4 different ranges to 4 different emails.
Please would love any help I can get. This will save my job as I get written up every time I miss the deadline. I know - why can't the email report be split up automatically? Because the company is too cheap to pay for it.
Thank you so much !
I really beg that you can help me. I'm not even sure if this is possible but I would love any help I can get!
Problem:
I receive an email report every morning around 2am with a subject and attachment name: Date 2014 Report Name.xlsx
I'm responsible for waking up early, opening the report, selecting four specific ranges (does not change) and emailing them to four specific people (either pasting it or screenshot).
If this does not get done by 6am I get yelled at and stuff hits the fan.
Hopeful Solution:
Would love to automate the process. If not completely at least partially.
1) Outlook rule/script to look out for the email and then perform action
2) Automatically select specific section of a sheet (ie/ Sheet 'Data'! - Range A7:F10) & either save as PDF or as a seperate xlsx or just copy it.
3) Email #2 to a specific user.
#2 & #3 would be run 4 times total, 4 different ranges to 4 different emails.
Please would love any help I can get. This will save my job as I get written up every time I miss the deadline. I know - why can't the email report be split up automatically? Because the company is too cheap to pay for it.
Thank you so much !