You could try using outlook object library. You may have issues with warnings coming up depending on your version of outlook.
Dim oOutlook As New Outlook.Application
Dim oMailitem As Outlook.MailItem
Dim oAttach As Outlook.Attachment
Set oMailitem =...
I have had a quick look at ado and also the union queries and it seems the query approach is quickest.
Thanks again for pointing me in the right direction.
Thanks Zion7
What is the advantage of using ADO over DAO - one of the the dbs is MSAccess so DAO seemed the natural one to use. Is ADO quicker or is it just a personal preference.
I am comparing 2 databases with approx. 60000 and 20000 records respectively.
I wish to find matches within fields in either db.
Which would be quicker - building to arrays or using dao.
Thanks.
Any ideas on how to change printers from a vb program.
I want my access program to send reports by fax and therefore need to select the correct option for the printer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.