Gmail Macro/User selects emaill address to send report to
I have been working on sending emails with the data I want which I have done successfully. At the moment if I want to choose a different email address, I have to change the macro. I would like an input box where the user can enter an email address to send the report to.
I've seen this working with outlook email macros but I can't get it to work with Gmail.
In the Outlook example I looked at, the script for emaill address is as follows - objMsg.To = "Email" Whereas I have to add the actual email address into the macro script.