|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround
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. |
#2
|
|||
|
|||
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 ? |
Tags |
excel 365, hyperlink email |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
Conditional function to operate a formula based on "Yes" or "No" Condition | Des ONeill | Excel | 1 | 07-03-2021 12:17 AM |
Stop Word from displaying {HYPERLINK "mailto:my_email@provider.com"} in Print Layout View | Stargehzer | Word | 2 | 11-17-2018 07:07 PM |
The "body of text" for all odd-numbered pages are all "vertically-centered-aligned". | keepcalmandreadabook | Word | 5 | 03-27-2017 04:08 PM |
Outlook: Hyperlink shows "Microsoft Office" files not "ALL" | Elly26 | Outlook | 5 | 02-22-2016 02:11 PM |