Hello Avinash

Please do this:


Register a new temporary spare gmail account, ( https://accounts.google.com/signup/v...owEntry=SignUp
https://www.lifewire.com/how-to-crea...ccount-1171924 )
( Use any name , Username and any Password).

Then contact me by PM message, ( http://www.excelfox.com/forum/privat...o=newpm&u=9041
)
Give me the Username and Password of the temporary gmail.

I will then tomorrow try to write a VBA macro using this temporary gmail address.
If it works, you can then change the gmail to a real gmail address and disregard the temporary one.


Alan


P.s. see also these Threads:
http://www.eileenslounge.com/viewtop...228710#p228710
http://www.excelfox.com/forum/showth...and-send-email
http://www.excelfox.com/forum/showth...kbooks-at-once