I want to send the attachment to about the 13 persons mentioned in the attachment, is there any possibility if I send this file to the 13 persons at the same time no body can see another data, i.e. if Mr A is seeing this file he must see only his row the others must be hidden.
If you know usernames of these persons you can put macro in Workbook_Open which loop through rows by Environ("username") and hide/unhide them.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Dear Mr KOKOSEK look at the attachment i have mentioned all the names,
Another approach could be to only send the line of data to each individual. I added the emails on the far right column. Try the following.
Please Login or Register to view this content.
If these names:
are matching with their usernames.Please Login or Register to view this content.
Please put these:
into ThisWorkBook code.Please Login or Register to view this content.
While closing all rows will be hide and when open macro check names in col. B and when it is matching with username unhide row for username.
So when you save it (with automatically hidden all rows), you can resend for everyone.
p.s. in attached file JAVAD is activeuser and his line is unhide (check comments in code).
Last edited by KOKOSEK; 04-19-2021 at 09:39 AM.
That's very good idea however OP wants to send attachment on email not pasted table into it.Originally Posted by maniacb
But you this macro can be used to send separate email with already hidden particular row.
Dear sir,
Thank you very much for your reply and help but
when i click on Email tab it opens up "Welcome to outlook 2016" whereas i am not using outlook but using google email.
as an example i have shown some of the email with name in the sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks