Hi
I have a macro which emails a report out to users based upon various details which is working as expected. The one issue I have is that I would like to be able to select a value in a cell that is the email address the message is to be sent from. At present the email will always come from my account but I would like it to be sent from a generic email accounts based upon the value selected in a cell. The user will have access to the generic account and their own personal account.
I have tried using set .sentonbehalfofname = "anaccount@ad.co.uk" and set .sendusingaccount = "anaccount@ad.co.uk" but the email is still showing as coming from my account.
I've had a look across the board, and at Ron de Bruin's site, but can't find anything to solve this. Can anybody help please.
I am using Excel and Outlook 2016.
Thanks
StewartS
I have a macro which emails a report out to users based upon various details which is working as expected. The one issue I have is that I would like to be able to select a value in a cell that is the email address the message is to be sent from. At present the email will always come from my account but I would like it to be sent from a generic email accounts based upon the value selected in a cell. The user will have access to the generic account and their own personal account.
I have tried using set .sentonbehalfofname = "anaccount@ad.co.uk" and set .sendusingaccount = "anaccount@ad.co.uk" but the email is still showing as coming from my account.
I've had a look across the board, and at Ron de Bruin's site, but can't find anything to solve this. Can anybody help please.
I am using Excel and Outlook 2016.
Thanks
StewartS