Recent content by LukeChung-FMS

Here's a new paper we wrote that offers additional information on how to configure Office365's SMTP server to allow email relaying and mailbox delegation. Those things need to be setup properly before Office365 allows you to use the SMTP server. There are also two login options: A specific...

Since Microsoft Access Web apps don't have reports, the ability to export reports to PDF or send emails, that's not going to be possible with the web platform. However, you can create a desktop MS Access application that connects to the Azure database on the web solution and create your...

GBalcom, No problem. We're aware that not every organization invests in developer tools for their Access developers unlike what they do for other programming professionals. That's unfortunate for all of us. Also too bad you're stuck in Access 2003. With Access 2007 or 2010 (and distributing...

There are a lot of limitations to the DoCmd.SendObject command. Here's our paper: DoCmd SendObject Command in Microsoft Access: Features and Limitations for Sending Emails If you're interested in a commercial solution that will automatically email personalized messages with filtered...

You could have this up and running in minutes with our commercial Microsoft Access Email product Total Access Emailer. It will let you send personalized emails to your list of contacts including attachments filtered to each recipient. You simply need to create a query with the list of email...

Take a look at our paper on the features and limitations of the DoCmd.SendObject command: http://www.fmsinc.com/MicrosoftAccess/Email/SendObject.html If you want your users to easily send personalized emails on their own to their lists and attach filtered PDF reports to each of them, I think...

Here's a paper we wrote that may help you: DoCmd SendObject Command in Microsoft Access: Features and Limitations for Sending Emails

Thanks for the link, but that doesn't seem to perform email validation. Did I miss something?

I'm not familiar with that library. Will all recent versions of Windows have that?

How would you run the VBScript regex from Access/VBA?

Wow, some people are so touchy. We have an algorithm that validates based on requiring an @ symbol not in the first character and appearing only once. Followed by at least one letter, followed by a . and at least one letter. The minimum length is 5 characters. Sounds like the guy needs to...

Here's a paper we've written that discusses the features and limitations of the Microsoft Access Docmd.SendObject command: fmsinc.com/MicrosoftAccess/Email/SendObject.html We also offer a commercial product, Total Access Emailer, that lets you send personalized emails to your contact lists...

If you're not a programmer and want to take advantage of combining Microsoft Access with HTML emails, consider our Total Access Emailer program. It will let you send personalized emails to everyone in your list (from a table or query) and even attach filtered reports as PDF files so each...

Here are some ways to work around the recordset is not updateable problem.

Here's a paper I wrote which you may find helpful in these situations: Dealing with Non-Updateable Queries and the Use of Temporary Tables in Microsoft Access Good luck. Luke