Hyperlink Function: Mailto with Body containing linebreaks

**Elipapa** · 11-07-2012, 05:09 PM

Hi guys,

I have list of email addresses in plain text that I want to send emails to in a spread sheet under column C, I would like to create a body saying the following:

Hi (Name taken from column A)

I contacted you back in (date pulled from Column J) and I wanted to follow up with you

so far i have the following formula to put into a separate column, but i can't figure our how to add a line break, and after that how to pull the date from column J

Anyone here that can help me out here?

Im using Excel 2008

=HYPERLINK("mailto:"&C4&"?&subject=Circling Back&Body=Hi "&A4&",

**benishiryo** · 11-10-2012, 02:22 AM

hi, Elipapa, welcome to the forum. you can have a read at this write-up i did. if you require direct help, do upload an example. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon

**Elipapa** · 11-12-2012, 03:09 PM

I've tried copying everything in the write up you posted Beni, but it doesnt look like its working yet. My mail program still posts a %0D or a %0A whenever I click on the created Hyperlink.

Ive posted an example of what I'm trying to do in this spreadsheet. eventually I also want to have cell references in the email body as well for first name and date contacted. but that is another topic

is the fact that I'm working on a mac relevant to the reason why i'm having this problem?

Email with Linebreaks.xlsx

**dredwolf** · 11-12-2012, 04:36 PM

I think your are looking for something like

....&CHAR(10)&...

Char(10) will return the LineFeed code

Hope that helps

-Edit-
or maybe
...&CHAR(13)&... (Carriage Return);
or
...&CHAR(10)&CHAR(13)&..(LineFeed and CarriageReturn);
or, on some cp/m based sytems, it could be
...&CHAR(13)&CHAR(10)&... (rare, but possible)