If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|