Search results

Thanks. I was making it more difficult than it is. I created another query and used an IIf statement.

I have to create a string either in a query or on a form (which hopefully can update a query). There is one numeric constant (1234) and another figure that comes from the input spreadsheet (Office -WXYZ) and in between them three variables. My big dilemma is that some branches have a “W” in...

I only needed to add one line: objOutlookMsg.To = Me.[Text113]

The problem is solved thanks to several of the posts above, which gave me hints. I can't believe how simple it was. I just added another line: objOutlookMsg.To = Me.[Text113] Thanks Again

Gasman: I appreciate your response! I’m not sure it quite meets my problem either that or I may be misunderstanding your code. I’m using DLookUp to find my email address Email1 from the table Contacts, based on matching the Allotment Code on the form to the Allotment number in the Contacts...

I'm using an Access form to populate an Outlook email template. I have been successful getting the data from the form into an email using this sequence Body = Replace(Body, "@1", Me.[BUREAU CODE]) with a control source tied to a specific table or query. My problem is one of my form fields...

I'm using an Access form to populate an Outlook email template. I have been successful getting the data from the form into an email using this sequence Body = Replace(Body, "@1", Me.[BUREAU CODE]) with a control source tied to a specific table or query. My problem is one of my form fields...

I got it to work - Thank you so much! I've been working on this for over a week and have read so many forum posts trying to find the answer. Good thing the boss didn't know how long I've been on the web lately. :) After your suggestion, I only needed to add objOutlookMsg in to .Display and it...

Is this what you meant? It now gives me a runtime error # 438 for .display Private Sub Create_Email_Click() Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem 'Create the Outlook session. Set objOutlook =...

I need to send an outlook template as an email from Access. When I use the code below it hangs up at “CreateItemFromTemplate” and I keeping an error message - “Compile Error: Method or data member not found.” I have the following references checked: Microsoft Access 14.0 Object Library...