Outlook Email from Excel

Hi,
I have a few macros that spit out emails in Outlook. In the past, they have worked perfectly. However, at my office, we recently switched to a new domain server. When I switched over, I dropped the personal.xlsb file in the XLSTART folder in my new login. Now, when I run these macros, they work, however, they always leave the body of the email blank. (I have a message that is hard coded) Everything else works. (To:, Subject, even attachments)

The macros still work on my old domain log in, oddly enough. Has anyone experienced anything like this?

Hi,
Technically, I was on a local non-domain profile, and now I'm on Azure AD. The code is below. I redacted a good bit. You will see the word REDACTED where that has been done. The first half or so of the code is formatting the spreadsheet. The emailing follows that.

Please Login or Register  to view this content.

Hi, I have changed it to .body, with no luck. If this helps, I'm on windows 11, with office 365. The macro is stored in my personal.xlsb workbook on my C drive. Also, oddly enough, when I step into the macro, and manually run it, using F8, it works.

Hi, it appears the issue has been solved. I tried what you suggested, with no luck.

Then, I changed .display to .send, and it worked. However, I really did not want the email to automatically send. So, I found a suggestion to move .display to the beginning of the email creation. That did it. It doesn't make much sense to me, but it worked.