[dctdatabase]

Hi there
am finalising a database for workplace and hoping to include feature to send emails to several people at same time from Access. I understand I need a code for this, can anyone help? We're running Access 2007 but using database in Access 2000 format. Worth noting that this is a secured database and I have already tried instructions at www.uwec.edu/HELP/Word03/MM-email.htm and http://support.microsoft.com/kb/208933 but no luck.

Also having problem importing data from Excel spreadsheet into that Access database. Worked several times before (including with some data in that spreadsheet) but now coming up with error (without any detaio about what's wrong). Spreadsheet contains loads of data on several worksheets and data has been worked on quite a lot (mainly for cleansing), all fields and formatting match those in Access and yet won't work any more. Any ideas as to what my be problem??

Thank you!

Sev

[OBP]

Sev, I have posted various copies of the emailing VBA some of it quite recently.
The Excel problem sounds like someone has put something in a cell that doesn't belong there, it is uaually text when Access expects a number. You should have an Import Error table generated with the rows and fields that have the error.

[dctdatabase]

Hi OBP
thanks for the reference. After a bit of digging I managed to find the posts you referred to so I'll have a go.
Sev