Hi! I'm new to Excel. I'm using a formula to send out emails from Excel. It appears there is a character limit for the body text of my email. Does anyone know how I can add more text without getting a value error? I provided my formula below! Thank you in advance!

like
Posting as :
works at
You are currently posting as works at

Here is my formula

Post Photo

Put all your data into a table in one drive send your emails via power automate.

The formula you provided is a hyperlink formula that creates a hyperlink to an email address. you could try to create a macro that does the same thing, you can use the following VBA code:


Sub SendEmail()
Dim EmailAddress As String
Dim EmailSubject As String
Dim EmailBody As String

EmailAddress = Range("B7").Value
EmailSubject = Range("B1").Value & Range("A7").Value
EmailBody = Range("B2").Value

ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "This is an email"
.Item.To = EmailAddress
.Item.Subject = EmailSubject
.Item.Body = EmailBody
.Item.Send
End With

End Sub



This macro will send an email to the address specified in cell B7 with the subject and body specified in cells B1, A7, and B2 respectively. You can assign this macro to a button or a keyboard shortcut for easy access.

I hope this helps!

Thank you so much!! I will try this tomorrow!!

Related Posts

Is this legal?
My partner and I are moving out of our condo building in NYC at month end, and the building management (not our landlord) has communicated to us that, on top of the 1K non-refundable fee and 1K security deposit to move out (stated in lease), they are also issuing a $1,250 "sanitization fee" for the public areas (hallways/elevators), since we happen to be moving out during COVID19. We feel this is taking advantage of tenants during this time and may not be legal. Any advice helps!

like

Why does it look like my phone's taking a screenshot everyone I bookmark a post??? 🧐

like

Hi All, Any update on CTS work from home extension?

like

How do people afford to buy $1M houses in Chicago? Surely not everyone buying them is rich (which is somewhat of a subjective term). My wife and I are 30 and have a combined income of almost $300k and trying to buy something that expensive seems asinine yet people do it. Am I missing something?

likesmartupliftinghelpfulfunny

Has anyone had a misdemeanor charge(s) and had to report it to NASBA when applying for the CPA? If so, how did you present the explanation of the misdemeanor charge(s)?

likehelpful

Anyone participating in DADI coin crowd sale? Why yes / no?

like

How much hike% I can expect with 3 rating in Capgemini. This is my first year with the company, Joined 10 months back.

Capgemini

like
like

What is your motivation to stay in IQVIA, India given the pay here is avg/below avg compared to market standards and learning curve is also not very steep?

like

Light & Wonder Let me know if anyone is interested in the below openings Light & Wonder

Post Photo
like

Not sure this is the right bowl for this really but anyway - does anybody have an idea of what Cerner does? I have an offer to join as Healthcare IT consultant but I BSed my way through every stage. I still actually have no idea what it is they do…

like

Gotta keep the Omega ready for that 1 time a year when I'm ready to wear it. My wife thinks I'm a pshyco 😀

Post Photo
like

Getting an offer from Accenture later this week. Wondering what to shoot for in TC for IT Manager role… I have 8yrs exp, MBA from state school, CISA, in MCOL city.

$165 base? Bonus?

Any advice on negotiations appreciated!

like

Larsen & Toubro Infotech I’m selected as a blockchain developer in LTI Hyderabad. HR is not disclosing the Project name. Are there good projects in Hyd location for blockchain? Please help me.
Thanks in advance.

Larsen & Toubro Infotech.

like

Hi Fishes,
My LWD in Wipro (my previous employer) was on 21 Aug, 2021. I was waiting to receive my outstanding due and experience certificate, as part of F&F, ever since. However, I received an email from the offboarding team today stating that my Final Settlement is on on hold due to security concerns (DLP: data leakage). How is this going to play out? And much longer will it take before my F&F process is completed and I get my outstanding due and my experience certificate? Pls advice.

like

What happened to iMedia Connection? Did they go out of business?

I'm overworked and I miss my family. I know some states are talking about "reopening" but I don't see an end to this.

like

What is the fix salary for manager position with 4.5 YOE in stat audit of Big4 India practice. I am getting 22.5lakh is it ok or should I ask for more?

like

Hi fishes,

Is there any openings in supply chain management in flipkart...
Can somebody give a referral
it would be of great help .

I am looking for a referral in marketing /operations role in flipkart at Bangalore location.

Anyone please out here who can hive referral

Additional Posts in Excel Genius

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Would anyone be willing to teach me vlookup?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Still don't have xlookup. #fomo

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal