Extraction of recipient mail id while opening macro of attached excel file for filtered data.

[dp4twt]

Hi Techies,
-One excel file is being attached containing data of various staffs
-The same needs to be sent to all staff under BCC
-When someone opens the attached excel file (under mail inbox), the data needs to be filtered on the basis of email recipient
-Hence, how to capture recipient mail id to the excel macro while opening the excel file. Can you pls help on this.
Regards
Thanks

 

[vletm]

dp4twt​

Your threads title gives image that this belongs to VBA Macros. ... Moved.
You should able to give more details as written in Forum Rules .. please reread it.

 

[BobBridges]

This is a strange request. I agree that there isn't much detail, but if I take it literally, it sounds like he wants something like this:

1) An email goes out to multiple recipients, with an Excel workbook attached.
2) Each recipient opens the email.
3) The OP wants each recipient to see only the parts of the attached workbook that apply to that recipient.

Can that be right, dp4twt? Off-hand I don't know how it could be done. Maybe if you write a program in VBA/Outlook, and persuade each of the possible recipients to allow auto-execute in his copy of Outlook (which I think is a very bad idea), and install your program in each of the recipients' copies of Outlook, then such a program could auto-execute whenever they open an email; the program would check the attachment, and if the filename matches the expectation then the program opens an instance of the Excel application, opens the attached workbook and modifies it according to the account name of the current recipient ...

But that's awfully complicated and a seriously dangerous idea anyway. Better, and much simpler, to write a VBA/Excel program that produces one workbook for each recipient, and then opens a copy of the Outlook application and sends one workbook to each recipient.