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!

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

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

KurtB wrote:

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!

--

Dave Peterson