VBA email macro converts text into numbers?

[Jyggalag]

Hi all,

I have this amazing email macro that @RoryA helped me build (big credits!).

He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time.

However, when I run it now, it converts my text into numbers for some reason?

For the email subject, I have these 3 subjects:

However, when I run the email code now, the subject ends up in numbers?

Any idea why? My excel cells are in "general" value format and the code looks like this:

Would appreciate some assistance here, thank you!
Kind regards,
Jyggalag

 

[RoryA]

The code looks at column A for the subject, not J.

 

[Jyggalag]

The code looks at column A for the subject, not J.

Wow can't believe I missed that

Fixed it now! You were indeed correct, as always

Thank you so much Rory! I promise to raise a statue of you in my future garden some day :D