Hi,
I have the mailto formula set up to create an email with the recipients, subject and body, but I am needing to add multiple cells worth of info into the body.
Best I have figured out is adding an & after each cell I just selected but then it just puts them all together without spaces or matching format.
Is there a way to have the mailto formula make the body of the email display all this info as it appears in excel (each row is different recipient)? (workbook attached)
The body would need to list all of the companies listed along with pay associated with each company.
thanks
Bookmarks