$x1 = New-Object -comobject Excel.Application $FilePath = "C:\Desktop\Review.xlsx" $UserWorkBook = $x1.Workbooks.Open($FilePath) $UserWorksheet = $UserWorkBook.Worksheets.Item(1) $UserWorksheet.activate() $rgeSource=$UserWorksheet.range(“A1”,“D9”) $rgeSource.Copy() | out-null $Outlook = New-Object -comObject Outlook.Application $Mail = $Outlook.CreateItem(0) $Recipients = '[email protected]'|ForEach{$Mail.Recipients.Add($_)} $Recipients | ForEach{$_.resolve()} $CC = '[email protected]'|ForEach{$Mail.Recipients.Add($_)} $CC | ForEach{$_.resolve()} $CC | ForEach{$_.Type=2} $Mail.Subject=“TEST as of $((Get-Date -Format 'dd/MM/yy '))" $oDoc = $Mail.GetInspector.WordEditor $oRange = $oDoc.Range() $oRange.InsertBefore("") $oRange.InsertParagraph $oRange.Collapse($wdCollapseStart) $oRange.Paste() $oRange.Collapse($wdCollapseEnd) $oRange.InsertAfter(“Thanks”) $oRange.InsertParagraphAfter() $Mail.Display() $Mail.Send()This is the code which works fine with outlook , it open excel file , copy data and paste it in message body and send the email. Now i want to do same but send emails using Gmail account.