Hello! Please help me with solving one problem. The fact is that I automate the process of sending an excel sheet as a pdf by outlook mail, and for this I write a macro: file - - - shared access - - - send by email - - - send as a pdf. When I write a macro, it is sent to pdf and there are no problems, however, when I run this macro, the file opens in the outlook window in the form of an excel workbook before sending it. I tried to send it from other devices, but the same thing happened.
Please tell me, what is the reason for this phenomenon and how to solve it?