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

[email protected] 800 200
[email protected] 801 300
[email protected] 802 400
[email protected] 803 500
[email protected] 804 600
[email protected] 805 700
[email protected] 806 800
[email protected] 807 900
[email protected] 808 1000
[email protected] 809 1100
[email protected] 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