My Dear Experts,
I need one big help... I am preparing weekly work tracker which is taking a lot of time to track manually.
I need help to create a VBA codes for this tracker to generate on weekly basis.
1. Automatically read and new entry in the data and send the summary via outlook to specific person.
I need support from this forum to create this report, Let me know if any more information required
Thanks
Please upload a workbook that includes a worksheet with raw data and a worksheet with how you want the raw data to look.
E-mailing is possible, but that is beyond my expertise, and may be best-addressed in the commercial services section for a Guru to take care of.
<---If my answer helped, please click *
Thank you for your reply Joe.
PFA the sample data, I have written a macro where if you click on "Submit" button it will send the complete excel sheet via outlook. I want to send only new entries as snapshot to email.
Is it possible?
What indicates that it's a new entry?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi Keebellah,
No indicator yet, but we have to consider "Request date" as new entry indicator.
Okay, I'll modify the code so that only filtered data is sent.
You say a snapshot do you mean a gif or other object or do you want to mail an Excel sheet with only the filtered data?
I meant to say can we send only new entry... for example only today's entry in excel sheet can we send in the mail body (a complete row details of new entry) and excel as attachment.
The entire Excel as Attachment?
Yes, that is working is if I am providing path in the code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks