I've the following problem and thought there should be a way to automate it to a certain degree.
We must collect a lot of documents once per year from our suppliers we work together.
The program team did this manually til now which took A LOT OF TIME and isn't really efficient.
I've made a macro in excel that pulls a text from a cell which is the message text for the mail. It replaces some keywords with information in other cells like supplier name, resource name etc...
The only thing that's missing (which would be the icing on the cake):
Please Login or Register to view this content.
Is it possible before sending the mails to recipients defined in a cell (have a look at the screen) that excel pulls information from another cell and writes down the information from there, also replacing keywords and attach that to the specific supplier?
E.g. I just want to sent a mail to the mail address in A which also includes a word attachment which pulls information from email text says something like "dear valued supplier, please confirm that the resources: replace_resource_name) are still working under a contract with you. Print, sign and sent the document back to us via mail as a proof of employment." replace_resource_name should be the names written in D.
So I need either once code before mine from above or another solution which does the trick.
Every supplier need their own attachment with their resource names in it.
Is that even possible or am I thinking "too easy"?
I'm using Office 2013. If you need more information please let me know.