Sending Email Using Microsoft Access VBA

Sending Email Using Microsoft Access VBA

If you use the later versions of Microsoft Access, you will have probably come across the tool to set and manage emails to normally Microsoft Outlook from a selected table or query and select individual valid records but this can be problematic with connection, server and services if not correctly configured.

There is a custom built solution which talks about sending email using Microsoft Access though it is not a free utility, it does have a free locked demo to evaluate and the following video (5 mins) explains a bit more about it…

httpvh://www.youtube.com/watch?v=M4T6EyCB7Xk

If you are feeling brave enough, you can build your own version and in fact the author Continue reading “Sending Email Using Microsoft Access VBA”

Microsoft Access Database Names and Reserved Word Problems

Microsoft Access Database Names and Reserved Word Problems

Designing your Microsoft Access database requires a plan, some dedicated time and vision, and without some scope for your new database, you can easily fall at the first hurdle when building and implementing a system with the lack of attention to detail of using key names and reserved words.

Some of the reserved names and words can be used depending where it’s being utilised but some will prompt you with a warning as being ambiguous because they are properties of forms, reports, sections, tables, or global names and constants from the Application object and the DAO, ADODB and VBA libraries.microsoft access database reserved names and words

Because it would not be practical to provide a full list of all reserved names and words, like built-in function names, VBA constant keywords or Continue reading “Microsoft Access Database Names and Reserved Word Problems”