Hi we have a Macros excel platform where they can send emails by vendors by product classifications. we use that platform to dispatch our products everyday. the plat form generate order numbers, convert the accounts name to our custom name and use our format on the email subject and body and we need a bidding on that existing platform, we need to make some changes .
1 We have manual emails from spreadsheet and need a bulk individual email options for each vendor, one click 20 separate emails will go to the same vendor with 20 different our custom subjects.
2 when we process order manually and click on the Column B hyperlink and once the email open the cell color will automatically turn into yellow.
3 Any Customer name and address matches/duplicate in the spreadsheet column A will turn into red for the both 1st and 2nd or 3rd..... duplicate lines
4 if column K value is over $999 then place a note under column A "QUANTITY" Context that -"High value product please include a free Signature delivery on regular shipping cost" is can be add or delete by Vendors name
5. once we ran macros create 4 columnn A for Code B for manual email hyperlink C quantites and d for make model and year
6. attach all pdf attachments to the email from same directory if if the P.O number matches with the email subject p.o number.
7. add an option to put control over the attachment group, we can select which group need attachment or not, if attachment not found with the p.o number then the group email will provide the error massage with the missing p.o number from subject.
8 According to column F order number generate and add name on the subject like Order : Brian and the number 1, also need to add a date on the order subject.
10 After successfully process the group email change color or the cells