Email from Excel Using the Hyperlink Function with Dynamic Range

mgiglio3

New Member
Joined
Jan 10, 2019
Messages
2
Hello,

I have successfully used this formula to create a hyperlink: =+IF(OR([@Priority]="High",[@Priority]="Mid"),HYPERLINK("mailto:"&"?subject="&$T$1&"&body="&[@[Property Name]]&"%0A"&[@[Securitization Name/ID]]&"%0A"&TEXT([@[Square Feet]],"#,##")&" "&"Square Feet"&"%0A"&[@Address]&" "&[@City]&","&[@State],"Send Email"),"").

This will create this text in the body of an email:

Property Name
ID
xx,xxx Square Feet
Address City, State

I am of course using a table. I am wondering if I am able to do this with multiple rows based on how my table is filtered. The data to be included would begin with the first row that is filtered and end with the last row. I would like the body of the email to look like this:

Property Name
ID
xx,xxx Square Feet
Address City, State

Property Name 2
ID
xx,xxx Square Feet
Address City, State

Property Name 3
ID
xx,xxx Square Feet
Address City, State

Is there a way to do this?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,546
Messages
5,838,034
Members
430,527
Latest member
MyFace2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top