Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Commas in mailto Expand / Collapse
Author
Message
Posted Tuesday, June 27, 2006 8:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 9:06 AM
Points: 104, Visits: 176
I'm trying to add a hyperlink to a textbox to e-mail addresses.

The following will work: (1)
mailto:aa@bb.com

However, if I want to send it to multiple recipients, and separate them with a comma: (2)
mailto:aa@bb.com,cc@dd.com

The hyperlink is no longer active on the textbox. I can add multiple people to the cc and bcc fields like this: (3)

mailto:xx@yy.com?cc=zz@aa.com, dd@ff.com

Is there any reason RS doesn't like the format in (2), and is there a way around it?
Post #290395
Posted Tuesday, June 27, 2006 11:04 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 24, 2012 3:50 PM
Points: 52, Visits: 35
Have you tried using a semicolon instead?  try mailto:aa@bb.com; cc@dd.com
Post #290479
Posted Tuesday, June 27, 2006 11:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 9:06 AM
Points: 104, Visits: 176
Yes I have, that doesn't work either.
Post #290483
Posted Tuesday, June 27, 2006 12:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:08 PM
Points: 10, Visits: 16
If you find the solution to this, please share.
Post #290527
Posted Tuesday, June 27, 2006 11:08 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:36 PM
Points: 631, Visits: 236

Using syntax from, found by googling mailto:

http://www.ianr.unl.edu/internet/mailto.html

MailTo with Multiple Recipients

<a href="mailto:astark1@unl.edu,ASTARK1@UNL.EDU">

Andy




Post #290651
Posted Wednesday, June 28, 2006 7:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 27, 2014 4:08 PM
Points: 10, Visits: 16

Andy,

Before posting, please try it out on one of your reports and post. The syntax you mentioned doesn't work.

Post #290743
Posted Wednesday, June 28, 2006 3:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 15, 2013 6:15 PM
Points: 110, Visits: 730

Just saw this example as well, haven't tried it though so no guarantees:

<a href="mailto:someone@yoursite.com?cc=someoneelse@theirsite.com, another@thatsite.com, me@mysite.com">Email Us</a>

This example implies that there can only be one primary mailto recipient and the place to specify multiple additional recipients, separated by commas, is in the 'cc' area.

Good Luck   

 

 




maddog
Post #290933
Posted Thursday, June 29, 2006 3:58 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:36 PM
Points: 631, Visits: 236

Chandrasekhar,

I beg to differ, the trouble with mailto "features" is that they are dependant on the default email program you have defined on your workstation. I use Outlook 2003 and find that substituting the semi colon for the comma allows Alt-K to resolve this example, while Outlook Express automatically changes the comma to a semi colon after Alt-K.

The Example syntax is cited on the link I provided and found by googling.

Andy




Post #291044
Posted Thursday, June 29, 2006 9:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 9:06 AM
Points: 104, Visits: 176

It does work in HTML, but not in a report. Like I've said in my original post, it just removes the hyperlink alltogether when I have a , or ; after mailto: (except when doing CC).

If you have an .rdl that works with mailto:1@1.com,2@2.com etc please share.

PS: Yes I'm using Outlook 2003 as well if it matters. (It doesn't in my case, because the hyperlink is not even clickable, so it doesn't go to the e-mail client)

Post #291219
Posted Thursday, March 14, 2013 8:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 14, 2013 8:43 AM
Points: 1, Visits: 14
Here is a answer:
http://www.networksteve.com/enterprise/topic.php/SSRS_2008_mailto:_multiple_recipient_Problem/?TopicId=50266&Posts=0
Post #1431020
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse