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:
Thank you
JG
Bookmarks