Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice created from Excel ocr Access and sent via Outlook
Hi,
I am all new to this and do not know any programming. I have an excel sheet with Name, Address, e-mail address, amount to pay and an ID number. Is it possible to automate this and send an email with invoice to each and everyone of them? I would like for Outlook to atleast to put the different information in the body of the message to make an invoice. If I have to make another solution with the distribution addresses that is ok with me. I just dont want to copy and paste all the hondreds of posts into e-mails, because something will definatly go wrong, and it is very time consuming. I hope I managed to explain my problem so that you can understand. I have Office 2003 BR/ Peggy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice created from Excel ocr Access and sent via Outlook
Peggy,
Start with these pages, they should be of some help to you: http://www.rondebruin.nl/sendmail.htm http://www.mvps.org/dmcritchie/excel/email.htm and if those don't hit the mark, a web search for "send email with Excel" will give you many others. Once you've got the basic process working, you can return here for 'fine tuning' assistance. If you need help on adding any of the code to a workbook, then check out this page: http://www.rondebruin.nl/code.htm "PeggyBell" wrote: Hi, I am all new to this and do not know any programming. I have an excel sheet with Name, Address, e-mail address, amount to pay and an ID number. Is it possible to automate this and send an email with invoice to each and everyone of them? I would like for Outlook to atleast to put the different information in the body of the message to make an invoice. If I have to make another solution with the distribution addresses that is ok with me. I just dont want to copy and paste all the hondreds of posts into e-mails, because something will definatly go wrong, and it is very time consuming. I hope I managed to explain my problem so that you can understand. I have Office 2003 BR/ Peggy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invoice Numbers created automatically | Excel Discussion (Misc queries) | |||
would like to export an address book created in excel to outlook | Excel Discussion (Misc queries) | |||
How can I put/insert a "Paid" stamp on an invoice created in Excel | Excel Discussion (Misc queries) | |||
export from Access to Excel has created problems with | New Users to Excel | |||
How do I feed info from invoice I created to a Spreadsheet | Excel Discussion (Misc queries) |