MasterBash
New Member
- Joined
- Jan 22, 2022
- Messages
- 47
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
I am looking to do something like this. Column has the name of different animals (Sorry, the real worksheet has confidential data). Column C contains an hyperlink that I can click on =hyperlink(mailto:...) Send e-mail to $B1, etc.
Now, the list of e-mails is way too long, so I get a value error when using hyperlink().
What is the best way to get around this ? I do not believe it is possible to add a body text and a signature (optional) when using the Insert -> Link button.
Help would be very much appreciated.
USA | DOG | Send e-mail to DOG | List with too many e-mail address | |
CANADA | CAT | Send e-mail to CAT | Subject : | REQUEST… TO $B1 to $B4 depending on the link I click |
Mexico | PIG | Send e-mail to PIG | Body : | Hello, Please provide… to $B1 to $B4 depending on the link I click |
Germany | ELEPHANT | Send e-mail to ELEPHANT | Signature : | If that is possible to add a signature, possibly the one added to outlook ? |
I am looking to do something like this. Column has the name of different animals (Sorry, the real worksheet has confidential data). Column C contains an hyperlink that I can click on =hyperlink(mailto:...) Send e-mail to $B1, etc.
Now, the list of e-mails is way too long, so I get a value error when using hyperlink().
What is the best way to get around this ? I do not believe it is possible to add a body text and a signature (optional) when using the Insert -> Link button.
Help would be very much appreciated.