V
V
Vladislav2017-10-11 18:31:12
excel
Vladislav, 2017-10-11 18:31:12

How to make a link to an email in excel with a filled subject and text fields?

Already done, I’m writing to the toaster in line 1 as a note for myself for the future.
Given:
There is a cell with a person's email address, a cell with his full name, some kind of welcome text. There are more than 100 such cells, I don’t need the result myself, it’s not an option to explain about macros.
59de37cb74888780960241.png
It is necessary:
​​Make it so that on click the mail client opens with the subject of the letter and full name already filled in.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladislav, 2017-10-11
@Sabin

In cell C2, enter the following formula:
Result:
59de399678ab2942995977.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question