Hello,

I am trying to figure out a work around for my excel sheet of data. I am creating this excel sheet to assist my non-technical team in sending emails with unique information. So by doing this they would input the account number and reason they are sending an email, so through other formulas it will generate the names, emails, and everything they need into the excel sheet. I am working on a hyperlink that they can click that will generate the response based on one of the reasons they entered the account information in the excel. So in each individual email we could have different "to:", different "bcc:", different "Subject" and a different "body". The body is a massive 1 pager on Microsoft word. This formula reads as follows:

“=hyperlink(“mailto:”&K3&”;”&N3&”;”&P3&”? subject=“&Q3&”&bcc=“&R3&”body=“&S3&T3,”Send Email”)



I realize that the reason I’m getting the “#value” error is because the body is too large. Any suggestions on a workaround? I am borderline clueless to vba and have researched what I’ve seen on here. It gets tough trying to make it specific to my needs for the first time using it. I initially had this built out on mail merge with about 5 different templates for mail merge, however this information is updated daily so we try to keep it stored on teams. By storing on teams, mail merge has some huge functionality issues. Any help is appreciated.

Attached Files

Hyperlink Example.xlsx (11.1 KB, 8 views)

Can you accomplish your email goal by using ONLY Excel ?

If so, can you accept a Log-In page that will direct them to their individual "email"
page where they can input the required data for sending ?

When you say you are receiving an error that the Email Body is too large .... how big
is the body ?