Jump to content
Sign in to follow this  
t0nZ

GAB2OAB Google contacts to Outlook Contacts

Recommended Posts

I was in a hurry to convert 200+ address book from Google Contacts (G Suite, contacts exported in .CSV with Google Takeout, but the contact format is the same for every Google Gmail account)  to Outlook contacts, so I developed this quick and very dirty script.

Starting from a .CSV exported from Google, you can run the script and you have the contacts ported directly (no outlook import) on the Outlook Address book.

In my experience, the fields of Google contacts are not fixed in number (!) and maybe also in position, so I made the choice  to import only certain fields to Outlook, scanning every line.

These fields, exact google names:

        "Given Name"  
        "Family Name"  
        "E-mail 1 - Value"  
        "E-mail 2 - Value"  
        "Phone 1 - Value"  
        "Phone 2 - Value"  
        "Website 1 - Value" 
        "Notes"  
        "Name"  
        "Address 1 - Formatted"  

Also the lines of google contacts can be weird as CR and LF are not "regular".

I include my code, (worked with no errors on a lot of conversions) and also a very small fake adress book with examples of problems I encountered and resolved.

#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_Icon=Icone\Win98-ico\script_file_teal.ico
#EndRegion ;**** Directives created by AutoIt3Wrapper_GUI ****

;GOA2OAB
;G.oogle A.ddress B.ook 2 (to) O.utlook A.ddress B.ook
;(C) NSC 2019
; convert a google (takeout) address book to an Outlook Address Book

#include <File.au3>
#include <Array.au3>
#include <_Gollog.au3>
#include <MsgBoxConstants.au3>
#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <WinAPIFiles.au3>
#include <String.au3>
#include <Math.au3>


; *****************************************************************************
#include <OutlookEX.au3> ; super perla pearl outlook create contacts !!!!!
; *****************************************************************************
Global $oItem
Global $oOutlook = _OL_Open()
If @error <> 0 Then MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)
; *****************************************************************************



Global $ver = "V.0.8192", $tempdir = "c:\GAB2OAB_temp", $File2convert, $aRetArray, $workfile = $tempdir & "\work-GAB2OAB.csv", $workfile2 = $tempdir & "\WORK2-gab2oab.csv", $FINALab = $tempdir & "\NEW-ab.csv", $A3clean[0], $A4clean[0], $A5clean[0]

; Gollog Autogenerated Gui
$mygui = "G.oogle A.ddress B.ook 2 (to) O.utlook A.ddress B.ook " & $ver & "           NSC 2019"
gollog_ini($mygui, 600, 200, 50, 50, "0x0033cc", "0xA8D9BD", "courier", 8, 600, @ScriptDir & "\GAB2OAB_log.txt") ; initialization with colors and font choice, more options see the UDF
Gollog(">>>>>>>> GAB2OAB " & $ver)
$File2convert = FileOpenDialog("Select Google Address Book File", @DesktopDir & "\", "CSV (*.csv)", BitOR($FD_FILEMUSTEXIST, $FD_MULTISELECT))
Gollog("selected " & $File2convert)

If Not FileExists($tempdir) Then
    Gollog("creating " & $tempdir)
    DirCreate($tempdir)
EndIf

If FileExists($workfile) Then
    Gollog("deleting " & $workfile)
    FileDelete($workfile)
EndIf
If FileExists($workfile2) Then
    Gollog("deleting " & $workfile2)
    FileDelete($workfile2)
EndIf
If FileExists($FINALab) Then
    Gollog("deleting " & $FINALab)
    FileDelete($FINALab)
EndIf

cleanfile()

readfile()

cleanfile2()

readfile2()

write2Outlook()


Exit

Func write2Outlook()

    Gollog("---> Assigning Fields...")
    Sleep(300)

    Local $FirstName = 4 ; initialize with Yomi name - always empty in tested companies, low class workaround
    Local $LastName = 4
    Local $Email1Address = 4
    Local $Email2Address = 4
    Local $MobileTelephoneNumber = 4
    Local $OtherTelephoneNumber = 4
    Local $Webpage = 4
    Local $Body = 4
    Local $Fullname = 4
    Local $BusinessAddress = 4


    For $z = 0 To UBound($A5clean, 2) - 1
        ;If $A5clean[2][$z] = "Additional Name" Then $MiddleName = $z
        ; limit @ 10
        If $A5clean[1][$z] = "Given Name" Then $FirstName = $z
        If $A5clean[1][$z] = "Family Name" Then $LastName = $z
        If $A5clean[1][$z] = "E-mail 1 - Value" Then $Email1Address = $z
        If $A5clean[1][$z] = "E-mail 2 - Value" Then $Email2Address = $z
        If $A5clean[1][$z] = "Phone 1 - Value" Then $MobileTelephoneNumber = $z
        If $A5clean[1][$z] = "Phone 2 - Value" Then $OtherTelephoneNumber = $z
        If $A5clean[1][$z] = "Website 1 - Value" Then $Webpage = $z
        If $A5clean[1][$z] = "Notes" Then $Body = $z
        If $A5clean[1][$z] = "Name" Then $Fullname = $z
        If $A5clean[1][$z] = "Address 1 - Formatted" Then $BusinessAddress = $z
    Next
    Gollog("Fields Found !")

    For $i = 2 To UBound($A5clean, 1) - 1


        Gollog("Contact 2 Outlook line " & $i)
        ;Gollog($A5clean[$i][1])
        ; Create a contact with first- and lastname
        ; *****************************************************************************
        $oItem = _OL_ItemCreate($oOutlook, $olContactItem, "", "", "FullName=" & $A5clean[$i][$Fullname], "BusinessAddress=" & $A5clean[$i][$BusinessAddress], "FirstName=" & $A5clean[$i][$FirstName], "LastName=" & $A5clean[$i][$LastName], "Email1Address=" & $A5clean[$i][$Email1Address], "Email2Address=" & $A5clean[$i][$Email2Address], "WebPage=" & $A5clean[$i][$Webpage], "MobileTelephoneNumber=" & $A5clean[$i][$MobileTelephoneNumber], "OtherTelephoneNumber=" & $A5clean[$i][$OtherTelephoneNumber], "Body=" & $A5clean[$i][$Body])
        If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemCreate ", "Error creating a contact'. @error = " & @error & ", @extended = " & @extended)
        ; Add a picture to the contact
        ;$oItem.AddPicture(@ScriptDir & "\The_Outlook.jpg")
        $oItem.Save()
        ; *****************************************************************************

    Next
    MsgBox(64, "OutlookEX UDF: the magic was made!", "All contacts successfully created ")

    _OL_Close($oOutlook) ; close the connection to Outlook
EndFunc   ;==>write2Outlook

Func cleanfile()

    Gollog('start check for unwanted LF... / final rogue "')
    Sleep(300)
    Local $A2Clean = FileReadToArray($File2convert)
    ;_ArrayDisplay($A2Clean, "original file", Default, 8)


    Local $dimLIST = UBound($A2Clean) - 1
    Local $string2write = ""
    Local $Astring1 = ""
    Local $Astring2 = ""

    Local $salvaAstring1 = ""
    Local $openLF = 0 ; we are between "LF" across lines

    For $i = 0 To $dimLIST
        Gollog('workin on line ' & $i)
        ;Gollog($A2Clean[$i])

        $Astring1 = StringToASCIIArray($A2Clean[$i])

        ;_ArrayDisplay($Astring1)
        Local $DimAstring1 = UBound($Astring1) - 1

        If $openLF = 1 Then
            ;check new line if start with "
            $Astring2 = StringToASCIIArray($A2Clean[$i])
            If $Astring2[0] = "34" Then

                ;       gollog('found initial " ')
                $openLF = 2
            Else
                Gollog('error new line not starting with "')
                MsgBox(48, "error", 'error new line not starting with "')
            EndIf
        EndIf

        If $Astring1[$DimAstring1] = "34" Then
            ;   gollog('First line -> Found final "')

            If $openLF <> 0 Then
                $salvaAstring1 = $salvaAstring1 & $A2Clean[$i]
            Else
                $salvaAstring1 = $A2Clean[$i]
            EndIf

        Else
            _ArrayAdd($A3clean, $salvaAstring1 & $A2Clean[$i])
            ;Gollog("adding to cleaned array state:" & $openLF)
            $openLF = 0
            $salvaAstring1 = ""
        EndIf

    Next
    Gollog('end clean from rogue "')
    ;_ArrayDisplay($A3clean, 'cleaned from rogue "')

    ;___________________________________P-PP-PP,P-------------------------------------------------
    Gollog('Start joining lines based on ODD " ')
    Sleep(300)
    ;_MathCheckDiv ( $iNum1 [, $iNum2 = 2] ) pari e dispari perla pearl



    Local $hFileOpen = FileOpen($workfile2, $FO_APPEND)
    If $hFileOpen = -1 Then
        MsgBox($MB_SYSTEMMODAL, "", "An error occurred whilst writing the file.")
        Return False
    EndIf

    Local $dimLIST = UBound($A3clean) - 1
    Local $Astring1 = ""
    Local $Astring2 = ""
    Local $dimSTRING = ""
    Local $AapiciINriga
    Local $numeroapiciINriga = 0
    Local $sommaNumeroapiciINrighe = 0
    Local $salvaAstring1 = ""
    Local $dispari = 0


    For $i = 0 To $dimLIST
        Gollog("workin' on line " & $i)
        $Astring1 = StringToASCIIArray($A3clean[$i])
        ;_ArrayDisplay($Astring1)
        ;Gollog($A3clean[$i])
        $AapiciINriga = _ArrayFindAll($Astring1, '34')

        If $AapiciINriga <> -1 Then
            $numeroapiciINriga = UBound($AapiciINriga)
            ;   Gollog("N° " & $numeroapiciINriga & "  apici in riga " & $i)
            $sommaNumeroapiciINrighe += $numeroapiciINriga
            If _MathCheckDiv($sommaNumeroapiciINrighe) = 1 Then
                $salvaAstring1 = $salvaAstring1 & $A3clean[$i]
                $dispari = 1
            Else
                Local $towrite = $salvaAstring1 & $A3clean[$i]
                ;       gollog("scrivo " & $towrite)

                FileWriteLine($hFileOpen, $towrite)
                $salvaAstring1 = ""
                $sommaNumeroapiciINrighe = 0
                $dispari = 0
            EndIf
        Else
            ;   Gollog("zero apici in riga " & $i)
            If $dispari = 1 Then ;linea vuota o senza apici ma " aperte dispari
                $salvaAstring1 = $salvaAstring1 & $A3clean[$i]
            Else
                Local $towrite = $salvaAstring1 & $A3clean[$i]
                ;       gollog("scrivo " & $towrite)

                FileWriteLine($hFileOpen, $towrite)
                $salvaAstring1 = ""
                $sommaNumeroapiciINrighe = 0
                $dispari = 0
            EndIf
        EndIf

    Next

    Gollog('END joined lines based on ODD "')
    ;_ArrayDisplay($A4clean, 'joined lines based on ODD "')
    FileClose($hFileOpen)

EndFunc   ;==>cleanfile


Func readfile()
    gollog("reading work file and creating multiD array")
    Sleep(300)
    $A4clean = FileReadToArray($workfile2)
    If @error = 1 Or @error = 2 Then
        gollog("error reading work2 file " & @error)

    Else
        ;       _ArrayDisplay($A4clean, "cleaned 1", Default, 8)
    EndIf
EndFunc   ;==>readfile


Func cleanfile2()

    Local $dimLIST = UBound($A4clean) - 1
    Local $Astring1 = ""
    Local $conta = 0
    Local $salvaconta = 0
    Local $dimSTRING = ""
    $salvalinea = ""
    Local $standardNumeroVirgole = 0
    Local $hFileOpen = FileOpen($FINALab, $FO_APPEND)
    If $hFileOpen = -1 Then
        MsgBox($MB_SYSTEMMODAL, "", "An error occurred whilst writing the file.")
        Return False
    EndIf


    Gollog('Checkin , number')
    For $i = 0 To $dimLIST
        ;Gollog('workin on line ' & $i)
        $Astring1 = StringToASCIIArray($A4clean[$i])
        ;_ArrayDisplay($Astring1)
        $dimSTRING = UBound($Astring1) - 1

        For $y = 0 To $dimSTRING
            If $Astring1[$y] = "44" Then ; secondo step ,
                $conta += 1
            EndIf
        Next

        If $i = 0 Then
            $standardNumeroVirgole = $conta
            gollog("----------numero virgole -> " & $standardNumeroVirgole)
        EndIf

        If $conta = $standardNumeroVirgole Then
            FileWriteLine($hFileOpen, $A4clean[$i])
        EndIf

        If $conta > $standardNumeroVirgole Then
            Gollog('>>> Line ' & $i & ' Virgole' & $conta)
            $toprecise = $A4clean[$i]
            $tofinal = ''

            While StringInStr($toprecise, '"') <> 0
                $tofinal = preciseremoval($toprecise) ;super smart
                $toprecise = $tofinal

            WEnd
            FileWriteLine($hFileOpen, $toprecise)
        EndIf

        If $conta < $standardNumeroVirgole Then
            Gollog('<<< Line ' & $i & ' Virgole' & $conta)
            $salvalinea = $salvalinea & $A4clean[$i]
            $salvaconta += $conta
            If $salvaconta = $standardNumeroVirgole Then
                $salvaconta = 0
                FileWriteLine($hFileOpen, $salvalinea)
                $salvalinea = 0
            EndIf
        EndIf

        $conta = 0
    Next

    FileClose($hFileOpen)

EndFunc   ;==>cleanfile2

Func writeWORKfile2()
    Gollog("writing work file")
    If _FileWriteFromArray($workfile, $A4clean) <> 1 Then
        gollog("error writing work file " & @error)
    EndIf
EndFunc   ;==>writeWORKfile2

Func readfile2()
    gollog("reading work file and creating multiD array")

    If _FileReadToArray($FINALab, $A5clean, Default, ",") = 0 Then
        MsgBox(48, "errore", @error)
    EndIf

    ;_ArrayDisplay($A5clean, "cleaned 2", Default, 8)

EndFunc   ;==>readfile2



Func preciseremoval($Pclean)
    ; llllllllllllllllllllllllll ---- pass 1 for ",,"
    $Astring1 = StringToASCIIArray($Pclean)
    ;_ArrayDisplay($Astring1)
    $dimSTRING = UBound($Astring1) - 1

    Local $salvadelete = ""
    Local $cond1 = 0
    For $y = 0 To $dimSTRING

        If $cond1 = 1 Then ; , removed so exit from loop
            If $Astring1[$y] = "34" Then ; terzo step " in chiusura
                ;   gollog('Found right "')
                If $salvadelete = "" Then
                    $salvadelete = String($y)
                Else
                    $salvadelete = $salvadelete & ";" & $y
                EndIf

                $cond1 = 0
                ExitLoop
            EndIf
        EndIf

        If $cond1 = 1 Then
            If $Astring1[$y] = "44" Then ; secondo step ,

                If $salvadelete = "" Then
                    $salvadelete = String($y)
                Else
                    $salvadelete = $salvadelete & ";" & $y
                EndIf
            EndIf
        EndIf

        If $Astring1[$y] = "34" And $cond1 = 0 Then ;PRimo step  per primo ->"
            $cond1 = 1
            ;gollog('Found left "')

            If $salvadelete = "" Then
                $salvadelete = String($y)
            Else
                $salvadelete = $salvadelete & ";" & $y
            EndIf
            ;Gollog("debug" & $salvaApici)
        EndIf

    Next

    ;   Gollog("apici e virgole da togliere: " & $salvadelete)
    ;gollog("virgole  togliere: " & $salvaVirgole)

    If _ArrayDelete($Astring1, $salvadelete) = -1 Then
        Gollog("error in arraydelete apici " & @error)
        gollog(StringFromASCIIArray($Astring1))
    Else
        gollog(' PASS 1 removed unwanted ",," from line ')
    EndIf


    $Astring2 = StringFromASCIIArray($Astring1)
    $Pclean = $Astring2

    Return $Pclean


EndFunc   ;==>preciseremoval

You will need the OutlookEX.au3 ,  look at this link and also my logging UDF  _Gollog.au3, attached.

Used on Outlook  from 2010 to 2016/365 with no problems.

Hope this script can help someone.

 

TEST1.csv _GOLLOG.au3

Edited by t0nZ

Share this post


Link to post
Share on other sites

Hi @argumentum, I added the link in the first post  to the fantastic OutlookEX UDF (credits and many thanks to @water) , and my log UDF (gollog) is attached in first post.

Yess you are right c:\temp may be in use , changed !

Thank you for the tips.

Share this post


Link to post
Share on other sites

As soon as I find some spare time I will create a new function in OutlookTools to import contacts from a CSV file :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-06-17 - Version 1.5.0.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Done! Version 0.4.0.0 has a new function: _OLT_CSV_Import


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-06-17 - Version 1.5.0.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-06-27 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (NEW 2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By water
      Extensive library to control and manipulate Microsoft Outlook. This UDF holds the functions to automate items (folders, mails, contacts ...) in the background. Can be seen like an API.
      There are other UDFs available to automate Outlook:
      OutlookEX_GUI: This UDF holds the functions to automate the Outlook GUI. OutlookTools: Allows to import/export contacts and events to VCF/ICS files and much more.  Theads: Development - General Help & Support - Example Scripts - Wiki
      BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort

      KNOWN BUGS (last changed: 2020-02-09)
      None
    • By PoojaKrishna
      Hi,
      I am trying to print items from Outlook in a Citrix machine. I am printing the items into PDF files using ‘Microsoft Print to PDF option’. I am using OutlookEX.au3 for printing items.
      Everything is working fine except handling the ‘Save Print Output As’ dialog appearing while trying to print the file to PDF.
      I have set the default printer to ‘Microsoft Print to PDF’ from the control panel ( Control Panel\All Control Panel Items\Devices and Printers) and using the following method to print the item.
      _OL_ItemPrint($oOutlook, $OL_Item) ;print item I am not able to handle the ‘Save Print Output As’ dialog initiated by the print statement in the Citrix machine. The WinActive method always returns false. I have tried with ControlSetText, ControlClick and Send methods also.
      Can anyone please help?
      Func _SavePDF($sFilePath) WinActivate ( "Save Print Output As", "") WinWaitActive ( "Save Print Output As", "",5 ) If WinActive("Save Print Output As") Then sleep(500) Send($sFilePath) sleep(500) Send("{ENTER}") sleep(500) EndIf EndFunc;=>_SavePDF  
    • By nooneclose
      I was running my script and everything was working fine and then it just stopped working. 
      I got this error message:
      !>12:51:55 AutoIt3.exe ended.rc:-1073741819 +>12:51:55 AutoIt3Wrapper Finished. >Exit code: 3221225477 Time: 354.6 I looked that error up and this article (https://www.autoitscript.com/trac/autoit/ticket/2541) said it was fixed a long time ago. 
      I am using version: SciTE Version 4.1.0, how am I getting this error? (first time I got it after running my code 50+ times)
      it crashed while trying to loop through emails. 
      Full output log:
      >"C:\Program Files (x86)\AutoIt3\SciTE\..\AutoIt3.exe" /run /prod /ErrorStdOut /in "C:\" /UserParams +>12:46:01 Starting AutoIt3Wrapper v.18.708.1148.0 SciTE v.4.1.0.0 Keyboard:00000409 OS:WIN_10/ CPU:X64 OS:X64 Environment(Language:0409) CodePage:0 utf8.auto.check:4 +> SciTEDir => C:\Program Files (x86)\AutoIt3\SciTE >Running AU3Check (3.3.14.5) from:C:\Program Files (x86)\AutoIt3 +>12:46:01 AU3Check ended.rc:0 >Running:(3.3.14.5): --> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop Action 1: Create a connection to the outlook account at line: 192 Action 1: Finished at line: 205 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Current email has been changed from Unread to Read. at line: 238 Current email has been changed from Unread to Read. at line: 238 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 3: Store vaild E-mails at line: 258 Number of unread E-mails: 17 at line: 290 Action 3: Finished at line: 292 Current number of processed Emails is: 0 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Opening a new Chrome window. at line: 2747 Action 8: Open Web Browser at line: 2240 _WDStartup: "MicrosoftWebDriver.exe" --verbose Action 8: Finished at line: 2270 Action 9: Navigate to Work Order Tracking at line: 2281 Action 9: Finished at line: 2295 Action 10: Click on Create New Work Order at line: 2306 Action 10: Finished Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660308 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 1 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660309 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 2 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660310 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 3 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660311 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 4 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660312 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 5 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660313 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 6 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: YT6508 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Long Description. Suite not needed. at line: 1475 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660314 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 7 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: CN2116 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Long Description. Suite not needed. at line: 1475 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660315 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 8 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: DT4905 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Work Order Number: 660316 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 9 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: YT6513 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 Young Tower has no suites! Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660317 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 10 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: BT3310 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Long Description. Suite not needed. at line: 1475 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660318 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 11 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: BT3411 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660319 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 12 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 Action 4: Finished at line: 361 Action 5: Store E-mail's contents at line: 371 Action 5: Finished at line: 495 Action 6: Test to Skip based on location at line: 508 Proper Building format used. Send Location: DT4519 Action 6: Finished at line: 710 Action 7: Check if location needs to be a suite at line: 720 The 'Bathroom' is not mentioned in the Description. Suite not needed. at line: 2180 Action 7: Finished at line: 2186 Action 11: Send E-mail Data to it's proper field at line: 2324 Sub-Action 3: Split Long Description at line: 2522 Sub-Action 3: Finished at line: 2576 Work Order Number: 660320 Action 11: Finished at line: 2511 Change status was called at line: 2758 Sub-Action 2: Change E-mail to Read at line: 2223 Current email has been changed from Unread to Read. at line: 2226 Sub-Action 2: Finished at line: 2230 Action 16: Create New Work Order at line: 2705 Action 16: Finished at line: 2719 Current number of processed Emails is: 13 at line: 2735 Action 2: Scan for invaild E-mails at line: 215 Number of SKIPPED unread E-mails: at line: 226 Number of SKIPPED E-mails: 0 at line: 246 Action 2: Finished at line: 248 Action 4: Loop through E-mails at line: 302 !>12:51:55 AutoIt3.exe ended.rc:-1073741819 +>12:51:55 AutoIt3Wrapper Finished. >Exit code: 3221225477 Time: 354.6  
    • By nooneclose
      Here is my code: Currently it finds all the unread, subject restricted emails in the inbox and its subfolders. (finds 15 when it should only find 4)
      $aItems = _OL_ItemFind($oOutlook, $mFolder[1], $olMail, "[UnRead]=True", "Subject", "Maintenance Request", "EntryID,Subject", "", 1) I want to find the emails in the inbox but I don't want to include the emails from the inbox's sub-folders. 
    • By nooneclose
      Morning, I am having trouble moving emails to a folder under another account's inbox. 
      Here is the code I have tried so far. 
       
      ; Access the Need Human folder under HELPDESK email account Local $nhFolder = _OL_FolderAccess($oOutlook, "helpdesk@hotmail.com\Inbox\Need Human") If @error <> 0 Then Exit MsgBox(16, "GC_WO_BOT:", "Error accessing folder 'helpdesk@hotmail.com\Inbox\Need Human'. @error = " & @error & " at line: " & @ScriptLineNumber) ;_ArrayDisplay($nhFolder, "Folder Access") ;MsgBox("", "email", $aItems[1][0]) ; Move the E-mails _OL_ItemMove($oOutlook, $aItems[1][0], Default, $nhFolder[5], "Need Human") If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_ItemMove", "Error moving specified Email. @error = " & @error & ", @extended = " & @extended & " at line: " & @ScriptLineNumber) ConsoleWrite("The current email " & $aItems[1][0] & "was just moved to: " & $nhFolder[1] & @CRLF) I get error moving specified email @error = 1, @extended = 1 
×
×
  • Create New...