VBA code .HTMLBODY issue

[netreg]

Hello folks

I am looking for some help with a problem that although small, is very frustrating

I have some VBA code that essentially reads a spreadsheet and create an email. the code works fine at home (Windows 10 pro), but at work (also Windows 10 pro), I get an error of Run-time error ‘287’ Application-defined or object-defined error. Both home and work I am using Microsoft Office Professional Plus 2016 version of Outlook.


It doesn't like the .HTMLBody at the end of the line of code;
.HTMLBody = Email & GetDataHTML & Emailpt2 & .HTMLBody.

If I remove the end .HTMLBody, it reads in the data but doesn't add my signature, if I comment out the line totally, it creates the email(s) with my signature, but obviously no data is read in from excel.


Only difference between home and work I can determine is that at work Outlook connects to an exchange server. Can anyone advise if this would be the issue?

 

[ParamRay]

Hello, please can you tell us:

1) Which data types the two variables Email and Emailpt2 are declared as; and
2) What the return data type of the function GetDataHTML is?

(Right-click the variables/function and select Definition from the context menu.)