Email a statement

[David]

I have to info below in a table format- I want to email the data specific to
one email address in one mail (mail merge) and then send the 2nd person
automatically his statement- is there a way of doing this in excell
i.e "a" gets inv 800 to 803, "b" get 804 to 810

email Inv No Amount

(e-mail address removed) 800 200
(e-mail address removed) 801 300
(e-mail address removed) 802 400
(e-mail address removed) 803 500
(e-mail address removed) 804 600
(e-mail address removed) 805 700
(e-mail address removed) 806 800
(e-mail address removed) 807 900
(e-mail address removed) 808 1000
(e-mail address removed) 809 1100
(e-mail address removed) 810 1200

 

[Ron de Bruin]

hi David

See this for a Outlook Body mail
http://www.rondebruin.nl/mail/folder3/row2.htm

There is also a attachment example on my site