Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

"Send Email To All" - How do I pass all the adresses to mailto hyperlink?

I coudn't figure out how to handle this, so I have a gridview of the Students who are registered to a class with their Username,Name,Email...etc. Email column is hyperlink with a mailto and it opens Outlook - working fine.
I added a new checkbox column with a "select all" header where you can select all or multiple rows by clicking the checkboxes on each row. And I added a button to the footer of the newly created column - Send Email. I can also capture all the emails of the selected rows from Email field.
So this is where I got stuck, this button could be an hyperlink also whichever works better. So I need to click and see that "array/string" of addresses in the To: field of the outlook.
How can I do this? I will post some code snippets also.

So basicly how will I put that "button" into the form of my hyperlinks within the gridview so that when I click it opens up outlook with the adresses I have, which currently I write on to the screen:)
---Gridview----
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataSourceID="SqlDataSource4" AllowSorting="True" 
                DataKeyNames="Email,Class" ShowFooter="True">
                <Columns>
                    <asp:TemplateField>
                        <FooterTemplate>
                            <asp:Button ID="Button1" runat="server" onclick="Button1_Click1" 
                                Text="Button" />
                            <br />
                            <asp:HyperLink ID="HyperLink6" runat="server">HyperLink</asp:HyperLink>
                        </FooterTemplate>
                        <HeaderTemplate>
                            <asp:CheckBox ID="CheckBox2" runat="server" 
                                oncheckedchanged="CheckBox2_CheckedChanged" Text="Select All" />
                        </HeaderTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox3" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="Username" HeaderText="Username" 
                        SortExpression="Username" />
                    <asp:BoundField DataField="First Name" HeaderText="First Name" 
                        SortExpression="First Name" />
                    <asp:BoundField DataField="Last Name" HeaderText="Last Name" 
                        SortExpression="Last Name" />
                    <asp:TemplateField HeaderText="Email" SortExpression="Email">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Email") %>'>
                            </asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:HyperLink ID="HyperLink7" runat="server" 
                            NavigateUrl='<%# Eval("Email","mailto:{0}?Subject=Course Inquiry") %>' 
                            Text='<%# Bind("Email") %>'></asp:HyperLink>
                        </ItemTemplate>
                    </asp:TemplateField>                        
                    <asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
                    <asp:BoundField DataField="Location" HeaderText="Location" 
                        SortExpression="Location" />
                    <asp:BoundField DataField="Instructor" HeaderText="Instructor" ReadOnly="True" 
                        SortExpression="Instructor" />
                </Columns>
            </asp:GridView>
 
----Code-----
//select all
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chk;
 
        foreach (GridViewRow rowItem in GridView1.Rows)
        {
            chk = (CheckBox)(rowItem.Cells[0].FindControl("CheckBox3"));
            chk.Checked = ((CheckBox)sender).Checked;
        }
    }
 
//get the checked ones
    protected void Button1_Click1(object sender, EventArgs e)
    {
        CheckBox chk;
 
        foreach (GridViewRow rowItem in GridView1.Rows)
        {
            chk = (CheckBox)(rowItem.Cells[0].FindControl("CheckBox3"));
            if (chk.Checked)
            {
                Response.Write(GridView1.DataKeys[rowItem.RowIndex]["Email"].ToString() + "<br />");
            }
        }
    }

Open in new window

0
askasp
Asked:
askasp
  • 9
  • 5
1 Solution
 
channa_mCommented:
You need to build the , delimitted string of email address and use Response.Redirect
 protected void Button1_Click1(object sender, EventArgs e)
    {
        CheckBox chk;
        string toAddressList = "";
        foreach (GridViewRow rowItem in GridView1.Rows)
        {
            chk = (CheckBox)(rowItem.Cells[0].FindControl("CheckBox3"));
            if (chk.Checked)
            {
                string emailAddress = GridView1.DataKeys[rowItem.RowIndex]["Email"].ToString();
 
                if (String.IsNullOrEmpty(toAddressList))
                {
                    toAddressList = emailAddress;
                }
                else
                {
                    toAddressList = toAddressList + "," + emailAddress;
                }
            }
        }
        Response.Redirect(String.Format("mailto:{0}?Subject=Course Inquiry", toAddressList));
    }

Open in new window

0
 
askaspAuthor Commented:
Thank you for your reply.
Well If I do the way you suggested then
- First I end up on a blank page (which could be solved probably by setting a target - not sure though)
- Second because of the Response.Redirect, I see all the emails in url such as my url looks like >>
mailto:aaaa@aaa.com,bbb@bbb.com,ccc@ccc.com?Subject=Course%20Inquiry

which I definetly don't want either of them.
0
 
channa_mCommented:
If you dont like using redirect, your other option is
 <script>
         function mailTo(toAddress){
             window.location.href="mailto:" + toAddress + "?Subject=Course Inquiry";
        }    
    </script>
 
 
   StringBuilder sb = new StringBuilder();
        sb.Append("<script type='text/javascript'>");
        sb.Append(String.Format("mailTo(\"{0}\")", t1.Text));
        sb.Append("</script>");
        ClientScript.RegisterClientScriptBlock(this.GetType(), "sendMail", sb.ToString());

Open in new window

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
askaspAuthor Commented:
sb.Append(String.Format("mailTo(\"{0}\")", t1.Text));

and what is t1.Text in your code?
0
 
askaspAuthor Commented:
Oh ok nevermind. I think I got it. So I tried and it worked but I am not familiar with that syntax at all so my code is now

 <script>
         function mailTo(toAddress){
             window.location.href="mailto:" + toAddress + "?Subject=Course Inquiry";
        }    
    </script>

        StringBuilder sb = new StringBuilder();
        sb.Append("<script type='text/javascript'>");
        sb.Append(String.Format("mailTo(\"{0}\")",toAddressList));
        sb.Append("</script>");
        ClientScript.RegisterClientScriptBlock(this.GetType(), "sendMail", sb.ToString());

How can i add the other fields to mailTo , like "bcc","cc" ...etc?
0
 
channa_mCommented:

<script>
         function mailTo(toAddress,cc,bcc){
             window.location.href="mailto:" + toAddress + "?Subject=Course Inquiry&cc=" + cc + "&bcc=" +bcc;
        }    
    </script>
 
        StringBuilder sb = new StringBuilder();
        sb.Append("<script type='text/javascript'>");
        sb.Append(String.Format("mailTo(\"{0}\",\"{1}\",\"{2}\")",toAddressList,ccAddress,bccAddress));
        sb.Append("</script>");
        ClientScript.RegisterClientScriptBlock(this.GetType(), "sendMail", sb.ToString());

Open in new window

0
 
askaspAuthor Commented:
Getting closer:)
I still couldnt figure out, there is a syntax issue here
    >>     window.location.href = "mailto:" + toAddress + "?Subject=Course Inquiry&cc=" + cc + "&bcc=" + bcc;

because it puts all the address and then "&bccaddresses" to CC in outlook and if I do

window.location.href = "mailto:" + toAddress + "?Subject=Course Inquiry&cc=" + cc + "&" + "bcc=" + bcc;

then it puts "&" to CC and the bcc adresses to bcc

Any suggestion?
And thank you for your time :)
0
 
askaspAuthor Commented:
To make it more clear:
First case looks like this
CC: &bcc=aaa@aaa.com,bbb@bbb.com

Second case looks like this
CC: &
BCC: aaa@aaa.com,bbb@bbb.com
0
 
channa_mCommented:
<script>
         function mailTo(toAddress,cc,bcc){

            var url="mailto:" + toAddress + "?Subject=Course Inquiry"
            
            if (cc !=""){
                  url = url + "&cc=" + cc
            }            
            if (bcc !=""){
                  url = url + "&bcc=" + bcc
            }            

            window.location.href=url
        }    
    </script>
0
 
askaspAuthor Commented:
I'll give it a try tomorrow the first thing and Thank you.
0
 
askaspAuthor Commented:
Thank you very much.
0
 
askaspAuthor Commented:
I actually have another question related with javascript again for a delete confirmation in gridview which is not a template column. But probably it would be better if I open a new thread for that, or can I just ask here again?
0
 
channa_mCommented:
Yes Please post a new request
0
 
askaspAuthor Commented:
If you would wanna follow-up here is the link to the new thread
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_24419031.html

and Thank you for your help on this one.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now