Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2022, 06:36 PM
MCamera MCamera is offline Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Windows 11 Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Office 2021
Novice
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround
 
Join Date: Mar 2022
Posts: 1
MCamera is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Hyperlink Example.xlsx (11.1 KB, 6 views)
Reply With Quote
  #2  
Old 03-02-2022, 07:52 PM
Logit Logit is offline Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Windows 10 Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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 ?
Reply With Quote
Reply

Tags
excel 365, hyperlink email

Thread Tools
Display Modes


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
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Stop Word from displaying {HYPERLINK "mailto:my_email@provider.com"} in Print Layout View Stargehzer Word 2 11-17-2018 07:07 PM
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround The "body of text" for all odd-numbered pages are all "vertically-centered-aligned". keepcalmandreadabook Word 5 03-27-2017 04:08 PM
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround Outlook: Hyperlink shows "Microsoft Office" files not "ALL" Elly26 Outlook 5 02-22-2016 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft