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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.