How to automate emails and invoices from Excel datasheet

[sonyabazonya]

Hi, I need help with automated invoices in excel.. I've looked at many VBA instruction videos but none help with Multi-Invoicing.. Basically I need to have an excel invoice that has commands to issue/create mutliple invoices and single ones and send by email. The info would be retrieved from a record list also in excel...

 

[ranman256]

You need a list, the VB would go thru the list and send the sheet.
Where do you get your list? How would the vb know which sheets to send?

 

[sonyabazonya]

Hi Ranman256, I would have a list ready and can be saved in a seperate sheet or in the same workbook.. the list would contain all the details per purchase.

thank you for your help!!!