=HYPERLINK("mailto:

[KurtB]

I am using the =HYPERLINK("mailto: formula to avoid copying and
pasting. I have a 2000 line spreadsheet and will eventual enter date
and send emails. I enter the date, location and color of paper being
ordered, I then send this information in an email.
I would like my email to be formatted with each section on separate
lines:
Date:
Location:
Color:

I have created the hyperlink using mailto, is there a way to format the
hyperlink output so my information appears on different lines. I have
tried an html "<P> and <BR>" I have tried word format "^p". Is
there a way to add this formatting?
Thanks!

 

[KurtB]

I also tried alt-enter in excel to make the excel line break.

 

[Dave Peterson]

You may want to look at all the tips that Ron de Bruin provides:
http://www.rondebruin.nl/tips.htm

Or even his SendMail addin:
http://www.rondebruin.nl/mail/add-in.htm