Search results

Hi @arnelgp, I have checked the code. I encounter an error when I modify the code to my existing table. kindly note this error is not in the attachment above. Specifically, these two lines sql = "select * from forEmail WHERE VariableName = '" & !VariableName & "';" sRecipients = rs1!mail...

hi, I think I worded my question wrongly. I am trying to say that the email should be generated from "dummy" table and the "recipient" of the email should be "course advisor". For example, Adam and Mina share same course advisor whose name is Nat. Therefore Nat who is a course advisor to both...

I want to modify the current solution given that currently the attached file generates an email according to students who belong to the same country. I have included a second table (Principal) to the attachment, and would like the "recipient" to come from "Principal" table. Scenario: Nat is a...

Hi, thank you @arnelgp for the time you put into helping me get a solution.

I think I was not clear in my question. the current db returns all records in the table for unique users. However, this time I want to return only select columns and corresponding rows in the form of "Country","Name" and "City" with alias Your country, Your name, Your city. Hence I was asking...

Hi, I also would like to return select columns to user, for instance "Country" AS [Your Country] and City AS [Your City]. I try to do this in the "zzforEmail" query so the table returns Your Country and Your City as the only columns in the outlook email. For some reason, when I click the...

Hi, this works perfect as I required. I cannot thank you enough.:) 🙏🙏 I have some more questions, I would like to input text in the body of the email before the start of the table, in form of a salutation message : "Dear Sir/Madam, Please find attached your corresponding information". Likewise...

Actually I did retype the entire code from scratch. It's quite annoying when the debug solutions I see online don't work.

Hi, kindly see the post where I have highlighted the line in Green. The first "End if" line gets highlighted in Debug mode. Thank you

I have this table and would like to send one email to Names of individuals who share same country. Name Country City School Email Adam TRNC Lefkosa CIU Adam@mail.com Mina TRNC Lefkosa NEU Mina@mail.com Graeme USA Missouri MUNI Graeme@mail.com Briann USA Nebraska NBUNI Briann@mail.com...

I have gone through the Allen Browne's output but cant seem to tailor it to my solution. I found a similar solution in the Send email to Unique Users in Range Thread. @arnelgp. In the solution I refer to, I also encounter problems in the specific line "Set rs2 =...

Attempt to bypass spam content error.

Hi @arnelgp. I have same situation and want to implement same using the code suggestion. However I keep encountering error on this line "Set rs2 = db.OpenRecordset(strQryEmailBody)". It appears nothing is parsed to this recordset. My modifications do not also work.

I have a MS Access table and want to send an email to each record in the table in a table format. For row in the table bearing same city or Country, I expect the outlook email to have those records in one table. I have included a dummy table whose records I would retrieve using an SQL query...

I am trying to post a question in the forum, but keep getting the contact administrator popup. The screenshot is a sample of my question I am trying to post.

How to retrieve a table in Access? this is just a sample quedtion

My name is Ben