Hi all,
I am trying to create a macro from a sheet formatted in the following way: (the sheet is a list of products we do not have in stock)
What I want to happen when I run the macro is an email is created/sent for each UNIQUE email address with a list of the parts that we have been unable to deliver to them.Please Login or Register to view this content.
So for the example above, the email would read:
I have played around with the following, but am struggling with a way to tell excel to compile all shorts with the same email...Please Login or Register to view this content.
Any help with this would be appreciated.Please Login or Register to view this content.
And also what code would include the default signature from my outlook?
Thanks in advance
Bookmarks