Sending to gmail through VBA

Hi,

Quite similar thread was closed too days ago (link).

TMS's code works smoothly (see below).

Problem: when I'm trying to take the red fields' (from TMS code) values from cells (rather than direct quote in "") the macro isn't working (without any error message).

Any idea why?

P.S. I've tried both .value and .text as suffixes. For example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Using Range.Value is the way Ron shows on his website.

@Tinbendr, I've followed Ron's advice and added twice ACTIVATE the relevant worksheet. This is still not working..

Please Login or Register  to view this content.

Ok an annoying mistake. I've been expecting to get the email in the gmail account that I defined as sender.. so all I've done is just to switch values in the .To and .From fields. Thanks also from here to Tinbendr who provided useful resource.

Just for future readers: In the to/from/cc/bcc you can:
A. Write the values as string: .To = [email protected]
B. Range("A1").value = [email protected], and then .To = Range("A1").value

Glad you got it sorted.