Hello,
I am trying to create an Outlook object email that poplates the fields in the email based on some named ranges I have in the Excel document. I have 2 sheets, Report and Distribution, the named ranges are on the Distribution sheet.
Here is my code:
When I manually enter the email adresses in the FROM, TO, CC fields it works but when I try to use named ranges like this it doesn't.
The named ranges contain the email addresses as well as the subject.
Does anyone know what I'm doing worng?
Thank you for the help!
Bookmarks