I have a Access 2k application that emails various report to customers with a PDF attachment using Outlook automation. The client currently uses Exhange Server and the VBA in the front-end application is the pretty standard code to create a outlook text message, passes it to Redemption Outlook (to bypass Outlook security prompts, etc.) and drops the email in the users Outlook Outboox.
Now the client is thinking of using Google Apps and Gmail rather than Outlook and the Exchange Server. I'm not that familiar with Google Apps right now and was wondering if this was possible because I'm thinking the Access 2000 application is not going to communicate with Google Apps. Seems like this environment is looking for .NET or JAVA languages.
Has anyone been able to create a VBA routine that will basically send an email from a Access application directly to a Google Apps Gmail account??
Any help, ideas, comments will be appreciated.