Hey,

I have the below code that when you highlight a role and run the macro, its opens a new outlook email and paste the relevant data in place to let a client know their package has been dispatched.

Please Login or Register  to view this content.
We are now going to be doing it a different way and contacting the branch with a list of items that were dispatched instead. So i need to do something similar so that when i highlight a group of rows and run it, it displays something along the lines of " The below clients items have been dispatched" and then a list of clients names, their reference and their tracking numbers. Lets just say those fields are in columns A,B and C to make it easier.

The email address will be similar to the above where it will be located in a cell, so if that can stay as data being pulled through, rather than a static one, thatd be great.

Thanks for any help you can provide,

Marc