kjhyder
Last Activity: Jan 17 '23, 05:56 PM
Joined: May 13 '22
Location:
-
The procedure has been working great without any issues. But now our external email provider has put a cap of 1,000 outgoing emails in a 24 hour period. This was not an issue until we have grown and now our agents exceed 1,000. They have set up a noreply@ email which I have access to send from that has a 10,000 email limit. Is there a way in the code to open the outlook emails in the noreply@ email instead of my khyder@ email so I do not run into... -
Thank you both for the assistance. I will input the code changes and test.Leave a comment:
-
I am using VB code to send out the emails from Outlook with Access. Below is a bit of my code regarding the emails and attachments.
...Code:Do While Not rs.EOF ' temp = rs("AGENT") MyFileName = rs("AGENT") attach = mypath & MyFileName & ".pdf" strEMail = rs![Email] & ";" ' DoCmd.OpenReport "R1099",Leave a comment:
-
Sending email through Access from secondary email address
I have an Access database that I send out emails to our customers. When the command button is selected it opens Microsoft Office and generates the emails for me to send. We have now created a general email address (like info@abccompany .com) that is shared among my team. It is possible to change the from address in Outlook for the emails generated from Access? So instead of being from my email address, they are from the general email address?
... -
Sending email through Access from secondary email address
I have an Access database that I send out emails to our customers. When the command button is selected it opens Microsoft Office and generates the emails for me to send. We have now created a general email address (like info@abccompany .com) that is shared among my team. It is possible to change the from address in Outlook for the emails generated from Access? So instead of being from my email address, they are from the general email address?
... -
Thank you ZMBD. It works great. Just what I was looking for. With a few cosmetic tweaks the powers that be will love it.
Once I am confident my process works, would there be a change in the code to have outlook send the emails automatically instead of me having to click send on each email that it brings up?Leave a comment:
-
Database
Thank you again for your assistance. I have uploaded the reduced database below....Leave a comment:
-
Sending Unique Emails to Distinct Recipeints
First off, I am new to using VBA in Access. I have had a request to email out activity statements to our agents with year to date transactions. I have built a table, query, and report in Access that shows this information. My report is broken down with a page for each distinct agent displaying only their transactions. I have used code from multiple sources online to come up with this:
...Code:Option Compare Database Private
Last edited by zmbd; May 27 '22, 09:09 PM. Reason: [z{[pending reply from OP - similar to current thread 977301}] -
After making the suggested changes (and removing the "Stop" and "Debug.Prin t", outlook opened with the first recipient (Brent) and attached the report. Except it attached the report as a whole and not just his unique page of the report. Also it sent one email per transaction line. Example: Brent had five transactions listed on his report and outlook sent 5 emails. Then it moved to the next recipient and create 6 emails since...Leave a comment:
-
The following show in the "Immediate" window
Line 39 - zsql = SELECT YTD.Pay, YTD.email FROM YTD WHERE (((YTD.email) Is Not Null));
Line 60 - zWhere= Brent Kendrick
Thanks againLeave a comment:
-
Just as you might have guessed, they would like the report as a pdf attachment. I have used your code and updated accordingly. I am receiving the following error.
Select VBNO
Error Number: 3075
Error Detail: Syntax error (missing operator) in query expression 'Brent Kendrick'.
Brent is the first name in my table. I run the debug and nothing comes up. Below is the code I have adapted from yours.
...Leave a comment:
-
Thank you both zmbd and ADezii.
Outside of some formatting on the email body, I cam very close here.
In case the powers that be want to change their mind and have the information dispersed in an attached PDF instead of the email body, could you post the second database you mentioned with the "WhereCondition " in the DoCmd.OpenRepor t method?
ThanksLeave a comment:
-
Thank you for your response. I did not make my question clear in my original post. I have a report in Access that is grouped by customer listing out each invoice, payment, and payment date over the course of the year. The report is subtotaled by customer. I have also added page breaks after each customer. If I were to print the report, I would get an individual pages showing only one customer's data on each page. I would like the ability to create...Leave a comment:
-
Access Report to Send to Multiple Recipients
I have a report in Access that is grouped by customer with a page break after each customer so only their data is shown on the page. I would like to email the report to each customer with their individual data(page). I can get Access to email to each customer, but it emails the entire report and does not email only the specific customer. I attempted to create a Module to handle this and while it does email, it sends an email for each line of data...
No activity results to display
Leave a comment: