All,
A few weeks ago I was able to get the following formula to work as a way to start an email with an automatically populated "To:" field to multiple recipients.
This method requires the user to manually enter each cell into the formula manually which is not the most efficient method.
My main worksheet has the following columns: Company, Discipline, Name, Title, Email, Phone. This worksheet has all of the contacts that may be working on a project and is to be used as a starting point for each project. When I project is started, the user will duplicate this worksheet and then erase all contacts that do not apply to that project. Since each project will have different contacts in different cells, the manual approach to creating email shortcuts will simply waste time. I want to be able to create hyperlinks that email everyone from a given company (or combination of companies) without the manual update process.
So I did some research and came up with the idea to use TEXTJOIN combined with an IF statement to create the same string that resides inside the HYPERLINK code shown above.
This formula works perfectly and creates the same string that exists in the original formula. Unfortunately, when I plug it into the Hyperlink formula I get a warning that "a value used in the formula is of the wrong type of data".
While creating a sample document and, subsequently, simplifying the amount of data within, I solved the issue which was a 255 hyperlink character limit which means my Textjoin idea is actually working properly. Now I just have to figure out a way to get around that limit.
Bookmarks