Good day,

i have a macro who is currently sending range A1:N61 in the body of a email, and send it to a specific email in d6.. this macro worked for years no problem.

The issue i am having, is now my employee switched from outlook to gmail, for ease of access and licensing fees. But gmail doesnt support very well pasting a excel range in the email body, the structure is not respected, as gmail does not fully understand the excel coding as outlook would.

So i am facing 2 possible solution.

1) Save the file to PDF and attach it to the email instead of pasting it in the body
2) Find a way to copy/paste and format differently so Gmail won't derp it.

Any clue where to start?

This is my current code (without the email).

Please Login or Register  to view this content.