Hello,
I got worksheet called "Customers", colum A contains customer's name, B contains email-address, C contains name of the workbook (that this customer receives)
Workbooks are named "Book 1", "Book 2", "Book 3" etc. and are stored into "C:\Excel\Customers\Workbooks"
Point is that using this workbook called "Customers" I'm able to send multiple workbooks to wanted user. (Our company's using windows live mail).
Like shown below, when I press commandbutton "Send", Jimmy receives Book 1, Mike receives Book 1 and Book 2, and Jennifer receives Book 1 and Book 3.
Jimmy ---- [email protected] ---- Book 1 [SEND]
Mike ---- [email protected] ---- Book 1 [SEND]
Mike ---- [email protected] ---- Book 2 [SEND]
Jennifer ---- [email protected] ---- Book 1 [SEND]
Jennifer ---- [email protected] ---- Book 3 [SEND]
I'm not familiar with CDO-codes so I would really appreaciate help with this. I attached example-workbook
Bookmarks