Excel Email VBA

[nathanojG6]

Hi All

I have the following code which allows me to create an email from excel. It attaches the spreadsheet that I am in, but only copies over the relevent information that is assigned to the person it is being sent to. Further to this, I can also regulate which information that I want to send by filtering the fields.

However the problem that I am facing is that, I cannot get the code to populate the body of the email Please help

I have attached an example document with dummy data

It's this section of the code that is causing me problems:
Application.Dialogs(xlDialogSendMail).Show _
arg1:=Recipient, _
arg2:="Report for " & RegionToGet

Full code:

Please Login or Register  to view this content.

Thank you
JG