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).
Bookmarks