MS Access

[steve11]

Hi

I'm trying to create a macro to send an access table/report as an automated email attachment

Table:

Account Name amount email
99999 Mr x £100 [e-mail]
11111 Mr y £200 [e-mail]
22222 Mr z £100 [e-mail]

Two emails need to go out one to Bob with mr x & Y records on and one to Jill with mr Z records. I tried using SENDOBJECT but only got as far as sending the whole table to a mail message (no addressee etc)

Help.

[annodomini2]

Try the forum here, www.vbaexpress.com/portal.php

May be of more help.