Gasman
Enthusiastic Amateur
- Local time
- Today, 12:23
- Joined
- Sep 21, 2011
- Messages
- 14,223
Hi all,
I have posted this question in the MS Office forum
http://www.msofficeforums.com/outlook/35942-outlook-signature-template-excel-macro.html
but have not had any response.
I am hoping someone here might have come across this as and have a solution as I know I lot of you send emails from Access via Outlook.
Admittedly the source is Excel this time, but the process is the same?
My question was
I created a macro in an excel workbook that will take data from that workbook and send an email using an email template stored on a network drive and the path added to trusted locations.
All fine, works OK on my PC and a colleague's. However the person who would normally use it, no signature is attached to the email when displayed?
I've had a look at her settings and the only thing I could see when I go to Programmatic Access is that it states no antivirus found, yet AVG is on the PC.
I've installed the latest version just in case and now it says valid.
When she creates an email herself, signature works fine. If she uses a template that she opens from extra menu options on a user added toolbar, the signature works fine.
I've got rid of the warning and the email template opens now as normal, just with the normal signature missing
I tested on another computer and get the same result, but cannot see what the differences might be. The second computer that does not have the signature does not have any warnings.
Where would I start looking for anomalies please? Does anyone have any ideas?
I have posted this question in the MS Office forum
http://www.msofficeforums.com/outlook/35942-outlook-signature-template-excel-macro.html
but have not had any response.
I am hoping someone here might have come across this as and have a solution as I know I lot of you send emails from Access via Outlook.
Admittedly the source is Excel this time, but the process is the same?
My question was
I created a macro in an excel workbook that will take data from that workbook and send an email using an email template stored on a network drive and the path added to trusted locations.
All fine, works OK on my PC and a colleague's. However the person who would normally use it, no signature is attached to the email when displayed?
I've had a look at her settings and the only thing I could see when I go to Programmatic Access is that it states no antivirus found, yet AVG is on the PC.
I've installed the latest version just in case and now it says valid.
When she creates an email herself, signature works fine. If she uses a template that she opens from extra menu options on a user added toolbar, the signature works fine.
I've got rid of the warning and the email template opens now as normal, just with the normal signature missing
I tested on another computer and get the same result, but cannot see what the differences might be. The second computer that does not have the signature does not have any warnings.
Where would I start looking for anomalies please? Does anyone have any ideas?
Last edited: