Prev: data splitting
Next: #Name problem
From: PeggyBell on 20 Apr 2010 05:30
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
From: JLatham on 20 Apr 2010 07:40
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
 | 
Pages: 1
Prev: data splitting
Next: #Name problem