I need to build a Flow that will perform an automated process that will add contacts to Outlook, depending on the Excel file attached.
For each contact the process will keep in Outlook the full name, email address and phone number.
Note: After entering the contact name, Outlook changes the title of the window and this should be taken into account.
• In addition, search for any of the contacts on Google.com (not in the address bar but actually on the site itself). This is a search only and the search results are meaningless.
In the Outlook contact card, in the Job title field, write one of the following options: “Does not exist on Google”, “Google phone is compatible”, “Google phone is not compatible”.
The Flow will select the correct option by comparing the data in column D with the data in column E in the Excel file (as mentioned, no importance should be attached to the result obtained on the Google site).
At the end of the treatment of the contact, the current date and time must be entered in the “Treated B” cell
A total of 2 processes must be built, each of which will retrieve the data from Excel in a different way:
- The first will be done in a way that the excel file is open on the screen and the process collects from it and writes data to it in a way that mimics the operation of a standard user.
- The second will be performed through the dedicated commands for working with Excel as explained earlier in the document. The entry into the “Treated B” cell will be performed by the Invoke VBA command, which is actually running a macro code on the Excel file. Note - This command receives three necessary parameters: a path to a text file where the macro code exists, the name of the function The set of parameters can be, for example, a List (Of String) variable.
Can anyone help with this task?