Recent content by lucy1216

This may assist you as well: Google the following: Sending Google Mail (Gmail) from MS Access, VBA, Excel, Word...by Tony Hine

I used Allen Brown's code and made modifications to it: Private Sub cmdEmailConfirmed_Click() Dim rst As DAO.Recordset Dim db As DAO.Database Dim oOApp_001 As Outlook.Application Dim oOMail_001 As Outlook.MailItem Dim distro As String Dim strSql As String Set db = CurrentDb() 'Sets the email...

My apologies..could you walk me through the "edit"?

I have the following code, thanks to Stretchin'; however I need to update a table for each person emailed. [CODE]Private Sub cmdEmailConfirmed_Click() Dim rst As DAO.Recordset Dim db As DAO.Database Dim oOApp_001 As Outlook.Application Dim oOMail_001 As Outlook.MailItem Dim distro As String...

So sorry, where do I find information on using code tags?

First of all, to whomever reads and/or responds I thank you for your patience. I am using Access 2010/Outlook 2010 32bit I am relatively new to VBA and I am completely lost on how to accomplish the following: My database was built to facilitate approvals for accounts payable. My issue now is...

Thank you for your response; however, I got it figured out!

Please keep in mind that I am just starting out using VB. What I am trying to accomplish is this: I have a click event: Private Sub cbtnApproverSendApproval_Click() On Error GoTo Err_cbtnApproverSendApproval_Click Dim stDocName As String stDocName = "mcrEmailIncoming" *****...

Okay, so where on the properties tab do I put the IIf statement?

What I am trying to do is display a message when a calculated field on the form is 0 and another message if it isn't. I have a form that has a total for a table, an entry box to put in the total of an imported vendor spreadsheet and a calculated field to show the difference, if any. I am lost...

Hello everyone! I have been using access for about a year or so and am now rewriting the databases that I have created in VB. .... So I will have some questions!