SendMail Macro in Excel 2016

[stevewood1]

Hello,
I wonder if anyone can help me with a Macro issue.
We have an Excel form with a Macro that automatically emails the workbook. The line of code that does this is

ThisWorkbook.SendMail Range("Welcome!R3"), Range("Welcome!R6")
Where R3 contains the email address to send the email and R6 contains the subject line.
This is working fine with Excel and Outlook 2010 which is what I'm using but one of our offices has recently upgraded to Office 2016 and since are finding that the subject line is always blank.

I don't really have access to Office 2016 at the moment. I've had a quick look on someone else's computer but the subject line is either blank or a few foreign characters.

Does anyone have any ideas about what could be causing this and how I can resolve it?

Many thanks

 

[DanteAmor]

Try this

[COLOR=#333333]ThisWorkbook.SendMail sheets("[/COLOR][COLOR=#333333]Welcome").[/COLOR][COLOR=#333333]Range("R3").value, sheets("[/COLOR][COLOR=#333333]Welcome").[/COLOR][COLOR=#333333]Range("R6").value[/COLOR]