How I copy name, email, and phone number from excel into outlook contact WITHOUT ForEach&ReadRange - when the excel file is closed?

Help Studio
1

Hi,
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.
The allowing activities are:
(Same as before)- Use Application/Browser, Click,Keyboard Shortcuts, Type Into, Get From Clipboard, If, Assign, Terminate Workflow.
AND
Excel Application Scope, Read Cell, Invoke VBA.

Attention: we need to work with CLOSE excel file (when the excel file is close - I can’t use Keyboard Shortcuts Activity.
So for opening excel file I’m using Excel Application Scope Activity.)

• 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

The solution 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.

i saw couple solution here but when i download the xaml file and open in inside UiPath i
get an error : “doucument is unvalid”. please help me

2

@RonV,

Welcome to UiPath Community :tada:

I would advise to split your whole use case into smaller use cases like read excel file without read range, create Outlook contact etc.

Work on each and if you face any error create a question with all the details about it.

Posting whole use case would not be right approach to get the solution.

Thanks,
Ashok :slight_smile:

3

Hi, the question is from a job interview and I saw that it was already answered here in the forum. The problem is that when I try to develop the XAML file in UiPath it gives me an error: document is invalid. I would be happy if you could explain to me what the problem is with this file because I saw that we marked his answer as a solution.
I have attached a picture from Gustavo’s solution

Gustavo
Gustavo1102Ă—656 93.6 KB

4

@RonV,

Ohh ok. Have you tried this solution?

Thanks,
Ashok :slight_smile:

1 Like
5

like I said,
When I download the xaml file and open it in UiPath I get an error message: “document is invalid” so it turns out that I don’t see anything.
Can you open the file at your place? If so, I would appreciate it if you could upload an up-to-date xaml file with a solution. This will really help me, thank you very much

6

@RonV,

It might be happening because the xaml file is developed in Legacy compatibility and you are trying to open it from Windows project.

Try opening in Legacy project.

Thanks,
Ashok :slight_smile:

7

I am completely new to UiPath. Can you guide me to the solution of the exercise? I don’t have much time left to submit it.

If it is possible for you to upload an up-to-date XAML file of Gustavo’s solution, it would help me a lot.

8

Legaci
Legaci1278Ă—672 199 KB

I opened the project in legacy and it still gives an error. I would really appreciate it if you could send me a solution to the task I wrote at the beginning of the post. Thanks.

9

@RonV,

Try this.

BlankProcess5.zip (4.5 KB)

Thanks,
Ashok :slight_smile:

10

uipathpic
uipathpic1501Ă—843 56.1 KB

There is progress, the file is now opened, but there is one error as you can see in the picture.

But I don’t think what you sent meets the requirements of the task:

Can you explain to me what you actually sent?

Thank you.