Related Posts
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
Still don't have xlookup. #fomo
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Would anyone be willing to teach me vlookup?
Still don't have xlookup. #fomo
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Here is my formula
Mentor
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!!