Search results

I can not figure out what I am doing wrong. I keep getting the same outcomes, either the ambigious error or the expected sub error or absolutely nothing happening at all. Any ideas what I could be doing wrong? Am I able to attach and you could take a look?

I am going to attempt to work on this more today to figure it out. I did not have much luck on say or sun.

When I try to delete that line it tells me it will reset my project.

how do I fix the Compile Error: Expected end sub? The debugger is set at the Private Sub Command19_Click()

and now I'm back to expected error

when i click on my form in vb it is set to command19 and click. when I click on the modsendemail it is set on the same. both places show the code

now it says ambigious name Command_19Click as well as I had it set to pen the form on load and now instead i get that same error as well when i open the database

so now I am getting an Ambigious name detected: SendeMail

I think I may not know how to attach it.

ok I put the button on my form. I went to the "Event" tab in the property sheet and attached it to "On click" and it gave me a Compile error: Expected End Sub

ok, I found the VB and created a module and pasted the revised code you sent. Is the code set to open the email only? I assume the next step would be to attach it to the button, is that correct? How do I do that? Do I go into the property sheet or do I have to do it via the Code Builder?

I looked at the example and I understand it just fine but I'm in 2013 and I don't have a modules section under reports, instead, I have a macros section which has a macros export in it. Where do I put the code?

To confirm, where am I putting the code? I go to my "Create Email" button and go to Build Event then go to "Code Builder", is that right?

Private Sub SendeMail() Dim rs As Recordset Dim vRecipientList As String Dim vMsg As String Dim vSubject As String Set rs = CurrentDb.OpenRecordset("SELECT * FROM qry_Project_Team_By_Regions ") If rs.RecordCount > 0 Then rs.MoveFirst...

well, the code is not allowing me to put in what I think are my values. It keeps giving me errors telling me I'm doing it wrong and I have tried () and _ and many variations. Secondly, when I tried to post the code here, it says I do not have permissions. Also, what do you mean by tags?

The name of my query is qry_Project_Team_By_Region The name of the field is SME Email. I do not have a report. I have a form which has buttons only. One of the buttons is set up to run my query after entering the parameter. I created the button next to it to open the emails with the addresses...

Thank you Gina. So, is this as simple as creating a button. So here is what I'm thinking. I add a button on my form. I go to "Build" and I choose, "Code Builder". Then I would paste the code. Is this correct? If yes, then I would just need to update the code, changing it to open email only...

So just so I'm understanding this correctly, I would run the query via the button. I would have a button next to it that would automatically send an email to all the recipients listed in the query result. Oh, and I would absolutely not want it to automatically send as there would be no text in...

Hi Gina, Thank you for the information. Unfortunately, I have no idea what I am looking at on this page nor where or how I would begin to set this up to try it. Can you explain what the end result might be? i.e. does it actually create an email or just concatenate the result

Hello, I have read through so many threads and google posts my eyes are bugging out! I am beginner access user with no SQL experience. Here is what I am trying to accomplish: I have a query which runs and produces a result of Name, Department, Region,Phone, Email, I have a parameter...