Mail from Excel

[gv29]

Good morning,

I have the macro enclosed as it contains html code which allowed me to email a selection directly to a bunch of people. Recently my company policy changed and we are not allowed to open "web pages" with excel anymore.

This small changes rendered the Macro useless. The issue lies in the fact that the macro is trying to create a .htm file. Is there any way around it?

Thanks,

gv

[Logit]

.
This macro selects data from the indicated cells and places that information in to the body of the email. It also attaches a copy
of the worksheet as a PDF file. That portion of the macro can be deleted if desired.

Please Login or Register  to view this content.

[bakerman2]

@ Logit

FYI another way to get filename.

Please Login or Register  to view this content.

So this

Please Login or Register  to view this content.

can be reduced to this.

Please Login or Register  to view this content.

[Logit]

.
Thanks for the assist.

[gv29]

Thanks, but this doesn't solve my issue as I am trying to paste a table in the body of the email without creating the intermediary file.

Any suggestions?

[bakerman2]

Take a look at this one.
https://www.excelforum.com/excel-pro...ml#post5088234