Hi,
I created a macro code that will be used by 20 users.
This code sends at the end through Lotus Notes an email to different recipients with an attachment.
The code is in a network directory and not on every desktop of the users.
Depending on the user that runs the code, the attachment (is a workbook)
that will be created should have in a cell the lotus notes email address
of the user that runs the code.
Could you please help me to find a way to "extract" the email address with VBA ?
Thanks in advance,
Kotzo
P.S. I don't want to create 20 copies of the code, with the user email information in every copy.
I created a macro code that will be used by 20 users.
This code sends at the end through Lotus Notes an email to different recipients with an attachment.
The code is in a network directory and not on every desktop of the users.
Depending on the user that runs the code, the attachment (is a workbook)
that will be created should have in a cell the lotus notes email address
of the user that runs the code.
Could you please help me to find a way to "extract" the email address with VBA ?
Thanks in advance,
Kotzo
P.S. I don't want to create 20 copies of the code, with the user email information in every copy.
