Good evening,
I have attached code to convert a workheet to pdf, create an outlook email and attach created pdf to created email. On created email subject is delivery reference which is a range.
Currently I am using it without any problem. But it creates only one email. What i am trying to do is creating seperate emails with delivery reference numbers. For example currently I have 5 different delivery numbers as a result i want to create 5 emails. Subject of these emails should be delivery numbers.
Second goal is to save these emails to folder. I could not figure out it so far. I tried .SaveAs ("folder path"), it did not return error, did not work either.
I would like to know if these objectives are possible if an excel master would like to help.
Thanks,
Bookmarks