Hamidi Zare

its like going to a mercedes showroom and asking for BMW features

do you get it now?

first you have to get the number of records. you may use a macro within excel, define it globally to insert a line above all records in each file, get the number of the records below it using:

(in excel) in cell B1 write "=counta(a:a)"

you have to put it elswhere, not in A column!

then, you may use that number generated in B1 to tell you macro express that how many records are there, or the length of the array!

in that case, you have to repeat the comand to read your a1 record till a(n) for the entire table to last column(n)

if you did not get what I am saying, you can pass same excel file you desire to do, I will provide you the ME file which it works.

search for command in the program

you can use "launch program and activate" and browse for chrome.exe

add keyboard shortcut to launch incognito using ctrl+shift+n

then browse for gmail

add wait or put the command for complete load of page

then use TAB key to find username.... and so on

I will try to attach the macro now!

import the file and run it

put your comment

there are some typical things that you may add to it,

like maximizing the windows using keyboard shortcuts

and if you have multiple profiles on chrome, you may choose among them, and so on!

sendIncognitoEmail.mex