ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mail a file with a macro, changing the user session (https://www.excelbanter.com/excel-programming/416387-mail-file-macro-changing-user-session.html)

Bere

mail a file with a macro, changing the user session
 
Hi, I´m trying to create a macro for sending a file.
I´ve it done with the rondebruin instructions and it has worked ok.
But now I would like to run the macro from another PC (another user).
In this case I have a problem with the signature.
The macro stops when it´s trying to locate my html signature -the file has
my name
I would like a way to create the oft with the present user session and
therefore its signature. I mean, to load the signature depending whose
session is running the macro.
Maybe something like the default signature according to the session.
Thanks in advance


Greg Glynn

mail a file with a macro, changing the user session
 
Why is your signature being picked up from the other PC? That would
happen if you're logged in, but not if the other person was logged
in. Can you please explain how you're running the macro?

Greg


All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com