Hi All,
I wanted to create a =HYPERLINK email generator based on cell values in the active row but #VALUE reared its ugly head. It would work great if I didn't run into character limits, so now I must resort to macros.
The Recipient name, To: CC: Subject: Body: etc., will be filled in columns A, B, C, D, for example.
Each row will be for a different recipient, thus the above message components will vary row to row.
In the last columns (lets say column E), I'd like a hyperlink (or similar) to press and generate the email for that recipient.
Some values in the columns B, C, D containing the message components use CONCAT like if there are multiple "To" email addresses
Any help or ideas would be appreciated, essentially I'd like to run one macro that changes the above variables based on row value.
I wanted to create a =HYPERLINK email generator based on cell values in the active row but #VALUE reared its ugly head. It would work great if I didn't run into character limits, so now I must resort to macros.
The Recipient name, To: CC: Subject: Body: etc., will be filled in columns A, B, C, D, for example.
Each row will be for a different recipient, thus the above message components will vary row to row.
In the last columns (lets say column E), I'd like a hyperlink (or similar) to press and generate the email for that recipient.
Some values in the columns B, C, D containing the message components use CONCAT like if there are multiple "To" email addresses
Any help or ideas would be appreciated, essentially I'd like to run one macro that changes the above variables based on row value.