sending the current record only via email

[amy ratcliffe]

hi all
dont know if anyone can help me i am a bit of an amateur
on access97 (i know its old but we are getting xp very
soon). ive been building a database for work and it
currently contains 11000 records. I have a form with a
command button that i set macro to save record, open
outlook and send form and then move to next record.
Unfortunately this sends ALL records in the table as
attachment what I want it to do is send ONLY THE CURRENT
record by email...does anyone know if this can be done ??
Our tech guys dont seem to think so but advised me to post
on here.
thanks very much - appreciated.
p.s. modules scare me so if the answer involves one make
it easy for me to copy !!!! thanks

 

[Julio C. Sesti]

Macros just don't pack enough power. The best way to handle complex actions
in using VBA(Visual Basic for Applications). You will never master access
unless you learn this. I recommend the publisher, Wrox, for learning VBA.