Email attachments in 2003

[NYC2RDU]

I'm trying to attach a spreadsheet to an email via VBA code in 2003. The spreadsheet already exists and is not being generated by the database. So far everything I've found within these forums has failed to accomplish my goal.

Any assistance would be greatly appreciated.

 

[pbaldy]

Presuming you use Outlook, search on "automation", which will allow you to attach an existing file to an email.

 

[BrettM]

This is something that I played with a few years ago to process batch emails with attachments. There is a reference to attachments in it. Perhaps you can use some of it.

Regards Brett