Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Topic: Creating email hyperlink field Posted: 26 Mar 2012 at 4:54am
Hi, I've a name field on my report that I am trying to format so that when clicked it will open an email with that persons email address in the recipient's box. In my hyperlink tab in the Email Address box there's;
mailto: (at this point I click the formula editor and would like to concatenate on the email address field from the DB)
I only have the field name in the formula editor text:
{tbl_Presenters.EmailAddress}
Joined: 25 Mar 2012
Online Status: Offline
Posts: 11
Posted: 27 Mar 2012 at 4:33am
After a lot of online reading I have finally managed to get my email hyperlink field to work BUT when I click the name to open an email, the format of the email doesn't look quite as I expected. Here's my mailto formula:
"mailto:"+{tbl_Presenters.EmailAddress} +
"&body=Hi"+{tbl_Presenters.PresenterName} + "," +
"&body=Just a quick email remind you that this return is due in on 26/04/2012." +
"&body=Would appreciate if you confirm when this has been done and also please let me have a copy for our files." +
"&body=Many thanks and" +
"&body=Kind regards" +
"&body=Liz"
but within outlook the email is like this:
To:ABC@ABC.Com - which is good
Subject: bee-Company#: - I have tried entering empty strings to help the format but everything after the empty string doesn't not display
Body: HiLiz - again the same as the subject line empty strings to create blank spaces don't work, and I'm only getting the first line of the body outputted.
Can anyone see what I am doing wrong to cause only 1 line of the body to be outputted? Any help on the formatting would also be appreciated..
Thanks Paul
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged