Send E-mail from javascript using REST API - SharePoint

In SharePoint 2013 we can send emails using REST API where we can utilize SP.Utilities.Utility.SendEmail for doing the job. 

Note: The recipient is limited to a valid SharePoint user for security reasons.

function sendEmail(from, to, body, subject) { //Get the relative url of the site var siteurl = _spPageContextInfo.webServerRelativeUrl; var urlTemplate = siteurl + "/_api/SP.Utilities.Utility.SendEmail"; $.ajax({ contentType: 'application/json', url: urlTemplate, type: "POST", data: JSON.stringify({ 'properties': { '__metadata': { 'type': 'SP.Utilities.EmailProperties' }, 'From': from, 'To': { 'results': to }, 'Body': body, 'Subject': subject } }), headers: { "Accept": "application/json;odata=verbose", "content-type": "application/json;odata=verbose", "X-RequestDigest": jQuery("#__REQUESTDIGEST").val() }, success: function(data) { alert('Email Sent Successfully'); }, error: function(err) { alert('Error in sending Email: ' + JSON.stringify(err)); } }); } $(document).ready(function () { SP.SOD.executeFunc('sp.js', 'SP.ClientContext', SendEmails); }); function SendEmails() { var from = 'info@domain.com', to = 'toUser@domain.com', body = 'Email using REST API', subject = 'Email FYI'; sendEmail(from, to, body, subject); }

Note: You can add 'CC' and 'BCC' property also to send email, property 'results' having array.

Remove a specific class from all child elements, and add new class

$('#parentDiv').find("*").removeClass("old-class").addClass("new-class");

Useful Windows Command Prompt Commands

1. Command History: You can track down your command history.
c:\> doskey /history

2. Run multiple commands:You just need to put “&&” between each command and save some time.
c:\>winword && notepad && msexcel

3. See PC driver list :You can see all the drivers installed on your computer.
c:\>driverquery

4. Send an output to clipboard: Save the output of a command.
c:\>ipconfig /all | clip

5. Create Wi-Fi hotspot right from the command prompt
Before opening the Command Prompt to execute the commands needed for this, you need to open Control Panel and find Change adapter settings in the Network and Sharing option. There, click on the connection you are using and click on Properties. Now find the sharing tab and check the option “Allow other network users to connect through this computer’s internet connection.”

-Open the Command Prompt with administrative privileges and enter the following command to enabled hotspot:
c:\> netsh wlan set hostednetwork mode=allow ssid=Youthotspotname key=yourpassword

-start the Wi-Fi hotspot
c:\>netsh wlan start hostednetwork

-To stop it, simply enter this command:
c:\>netsh wlan stop hostednetwork

Upload Attachment to SharePoint Site List Item

Application Form Window

CODE ---------------------- using System; using System.Windows.Forms; using System.IO; using System.Security; using spClient = Microsoft.SharePoint.Client; namespace Upload_Attachment_SP_Online { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnBrowse_Click(object sender, EventArgs e) { var file = openFileDialog1.ShowDialog(); if (file.ToString() == "OK") txtFilePath.Text = openFileDialog1.FileName.ToString(); var x = txtFilePath.Text.Split('\\'); txtFileName.Text = x[x.Length - 1]; } private void btnUpload_Click(object sender, EventArgs e) { try { using (spClient.ClientContext ctx = new spClient.ClientContext("https://contoso.sharepoint.com/tc/")) { SecureString upwd = new System.Net.NetworkCredential("", "password1").SecurePassword; ctx.Credentials = new spClient.SharePointOnlineCredentials("jon.smith@contoso.com", upwd); spClient.Web myWeb = ctx.Web; spClient.List oList = myWeb.Lists.GetByTitle("TestList"); spClient.CamlQuery camlQuery = new spClient.CamlQuery(); camlQuery.ViewXml = "<view><query><where><eq ><fieldref Name='Title'/>" + "<value Type='Text'>Item1</Value></Eq></Where></Query></View>"; spClient.ListItemCollection collListItem = oList.GetItems(camlQuery); ctx.Load(collListItem); ctx.ExecuteQuery(); spClient.AttachmentCreationInformation aci = new spClient.AttachmentCreationInformation(); byte[] bytes = File.ReadAllBytes(txtFilePath.Text); MemoryStream mStream = new MemoryStream(bytes); aci.ContentStream = mStream; aci.FileName = txtFileName.Text; foreach (spClient.ListItem oListItem in collListItem) { spClient.Attachment attachment = oListItem.AttachmentFiles.Add(aci); oListItem.Update(); } ctx.ExecuteQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }

Replace "Tab Character" in Excel Active Sheet

TAB - horizontal tab Decimal Value is 9

---

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

Dim lRow As Long

Dim lCol As Long

   

    'Find the last non-blank cell in column A(1)

    lRow = Cells(Rows.Count, 1).End(xlUp).Row

   

    'Find the last non-blank cell in row 1

    lCol = Cells(1, Columns.Count).End(xlToLeft).Column

For i = 1 To lRow

    For j = 1 To lCol

        t = Cells(i, j).Value

        If (Len(t) > 0) Then

            If (Asc(Left(t, 1)) = 9) Then

                str1 = Mid(t, 2, Len(t))

                Cells(i, j).Value = str1

            End If

        End If

    Next

Next

End Sub

Rest API to check field value contains...

[site url]/_api/Web/Lists/GetByTitle('myList')/items/?$filter=substringof('ABC',Title)

Filter Unique Value in Array

var items = ['abc','pqr','abc','xyz','pqr','abc'];
var result = items.filter(UniqueElement); 

//result ['abc', 'pqr','xyz']


function UniqueElement(value, index, self) { 
    return self.indexOf(value) === index;
}