VBA code to check for Internet Connection

[crchasedvm]

I would like some help to create a code to check for internet connection.

I have a macro that emails automatically using gmail if there is an internet connection. As soon as there is no connection, I get an error. I need some help with some code within the macro to check for internet connection and proceed or popup a msgbox to connect to internet and rerun macro.

Any help appreciated.

 

[Michael M]

Not sure if this works for gmail....and to be honest, it's out of my league, but have a look here

http://www.mrexcel.com/forum/showthread.php?t=137860

 

[crchasedvm]

Thanks for that. I tried that and couldn't get it to accurately reflect connection status. The other trick, is I need it to run within the macro as an if then statement.