Hi,
I have a question regarding connecting excel Outlook with moving Files from Folder to Folder.
1. I have an Excel Macro that creates me a file saved as PDF in that location C:\Users\pllmkd\Desktop\Urlop\Wniosek urlopowy.pdf
2. Macro after creating the document also send an email from Outlook Application installed on the machine it works on with a plain text: "Someone has just submitted the new request".
What I would like to do now is to add to buttons to that email text:
a) Accept
b) Reject
When the User clicks Accept the created file is moved from the location C:\Users\pllmkd\Desktop\Wniosek urlopowy.pdf to C:\Users\pllmkd\Desktop\Urlopy\Wnioski zaakceptowane\Wniosek urlopowy.pdf
When the User clicks Reject the created file is moved from the location C:\Users\pllmkd\Desktop\Wniosek urlopowy.pdf to C:\Users\pllmkd\Desktop\Wnioski odrzucone\Wniosek urlopowy.pdf
is there a way to add that part in that EXCEL macro that created this message?
I'd be grateful for any help.
[EDIT] I basically can create a macro that can move those folders to desired folders, but my request is more about creating those buttons in the email text that trigger those macros
Regards,
Dawid
Bookmarks