I send out mails (using Outlook 2016) asking colleagues to fill up their leave details in the this format (sample shown):
Capture.JPG
I copy paste these details into a *.xlsx file for tracking leaves.
Is there a way that these details can be automatically put into *.xlsx file, directly from my Outlook mails, and I don't have to copy paste?
Appreciate any help in this regard.
How do they fill this in? Is it a table in the E-mail body, or is it in an Excel attachment to the E-mail?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Its a table in the email body.
Last edited by AliGW; 12-02-2017 at 02:08 AM. Reason: Unnecessary quotation removed.
And what needs to happen to it? Do you want it automatically copying to a new spreadsheet or appending in some way? If the latter, what does the existent spreadsheet look like?
I want it automatically copying to a new spreadsheet.
Last edited by shomyo; 12-02-2017 at 04:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks