Search results for query: *

Thank you, thank you Blorf and RoyVidar! You are the best!! It finally works! Yea! One final question: When the command button is clicked and the email is ready to be sent, a MS pop-up comes up and says, "A Program is trying to automatically send email on your befalf. Do you want to allow...

Here's my code. I changed some of the field names to what I intend to have in my database. Private Sub SCEmail_Click() Dim Email As String Dim Autonumber As String Dim EmailMsg1 As String Dim EmailMsg2 As String Dim EmailMsg3 As String Dim EmailMsg4 As String If Not IsNull(Me!Email) Then...

Hi - I wrote in that code and ran it. Now it tells me that I have a compile error: End with without with. Any thoughts on this again? Again thanks for all your help you've been giving me.

Hi Blorf, I am really bad at VB. I think I'm going crazy. I tried putting the isnull statement after .to in my code. But I kept getting messages about a null statement. I know it's because I leave my EmailAddress field blank. But I was wondering how would I write a statement to say if the...

I knew it was unclear when I posted it. Sorry. Let me rephrase - in my form I already have a command button that uses a macro to check certain fields that I made required before the user can save and close the form. But now I want to add this email code, too (but it's in VB). Is there some way...

Blorf and PHV - Thanks for your help! I got it to work! But now I have two other questions/problems. 1. Is there a way I can combine the VB email code to a macro that I had on that form before - it closed and saved the form while looking for required fields. 2. How do I write a code so that...

Hi, I am trying to automatically send a confirmation # email after placing an order. I have the orders placed on a form with a command button that will start the event procedure. However, when I run this code, I get a run-time error message: Outlook does not recognize one or more names. Then...

Have you tried to turn off the "Navigation Buttons" in the Properties of the Form? It is under the "Format" tab.