Kiloelectronvolt
Board Regular
- Joined
- Oct 5, 2015
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi All,
I'm in way over my head, but thought it'd be cool if this is something that can be done.
I'd like to have an "Email" Button on every row that will use the data in the columns before it and put that text into the subject line.
If my cell columns looked like this:
12345 Fake Street | House Renovation | Change Order 1 | John Doe | EMAIL
If I click email, It'd be cool if it would email "JohnDoe@FakeEmail.com" with the subject "12345 Fake Street House Renovation Change Order 1"
I found this string and broke it greatly.
More advanced question:
Can I make it include the text in the body "Hi "John Doe", Please see the attached document"
EDIT* I am using vlookup formula to pull the corresponding emails to the names in a second sheet.
I'm in way over my head, but thought it'd be cool if this is something that can be done.
I'd like to have an "Email" Button on every row that will use the data in the columns before it and put that text into the subject line.
If my cell columns looked like this:
12345 Fake Street | House Renovation | Change Order 1 | John Doe | EMAIL
If I click email, It'd be cool if it would email "JohnDoe@FakeEmail.com" with the subject "12345 Fake Street House Renovation Change Order 1"
I found this string and broke it greatly.
Code:
=HYPERLINK("mailto:" &G2 & "?subject=" & A2 & "&body=" & B2, "EMAIL")
More advanced question:
Can I make it include the text in the body "Hi "John Doe", Please see the attached document"
EDIT* I am using vlookup formula to pull the corresponding emails to the names in a second sheet.
Last edited: