How to automate emails and invoices from Excel datasheet

sonyabazonya

New Member
Joined
Jun 8, 2015
Messages
2
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...
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
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?
 
Upvote 0
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!!!
 
Upvote 0

Forum statistics

Threads
1,213,564
Messages
6,114,334
Members
448,567
Latest member
Kuldeep90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top