How do I extract data from Excel using INVOKE VBA

[Sisay]

How do I extract data from Excel using INVOKE VBA?
I have data in Excel and I want to copy this data to outlook and creat new contacts,
for example:
EXCEL DATA: Name: Meital, Phone number: 1234, Email: meital@gmail…
And to copy this data and create new contact in outlook.

The only functions we can use are
Use Application/Browser, Click, Keyboard Shortcuts, Type Into,
Get From Clipboard, If, Assign, Terminate Workflow.
Excel Application Scope, Read Cell, Invoke VBA.
I CENT USE FOR EACH METHOD

[Parvathy (PS Parvathy)]

Hi @Sisay

Check the below threads

How can I copy name, email and phone number from Excel into outlook contact?

Hi @meitalh, Please, take a look at the attached file. Main.xaml (9.0 KB) You must create a folder named “Data” in your project folder, and inside of it an excel file named “Contacts”. Just like this: [image] [image] [image] If this solves your problem, kindly mark this post as solution to close this topic. If you need extra help and/or have any question, please let me know Thanks!

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

Hi @Lior_Shamir Here is an idea of how you can you read all values considering that you can’t use a read range activity. As I don’t have Excel installed, I used the read cell workbook activity. So, you should replace them by the read cell value activity. Main - Copy (1).xaml (15.7 KB)

Hope it helps!!