How can I send an excel sheet in the body of an email?

[littlephoenix918]

Hi guys,

I am trying to do a macro where an email is generated that includes the excel sheet. Not as an attachment, but as a table in outlook, something that you would manually do with copy+paste.

I couldn't find anything online... can anyone help?

Thanks,
M.

 

[Belleke]

a starter

 

[littlephoenix918]

a starter

that's very helpful, thanks

 

[Belleke]

Glad to help, and thanks for the feedback.