General :: Auto Email Personal Reports To Multiple People Automatically
Nov 21, 2013
I have put together some Access 2010 Databases and I am about to embark on another soon. I have been given a request that I can't seem to solve yet so I am goint to ask it here as a good starting point. The goal is to build a database for a magazine. They want to be able to run a report to generate slips for subscribers whose subscriptions have expired. I would like to, if possible, generate reports and send them to the respective clients via email, all with the push of 1 button. I don't want to have to find each subscriber and do one off reports.
View Replies
ADVERTISEMENT
Jan 10, 2013
Access 2007 DB. Is there a way to have an auto gen. email sent to me and or other admin. After user has completed input into form...
View 1 Replies
View Related
Jan 21, 2013
have a vba code written to have my MS Access 2007 tell Outlook to send an e-mail with several attachments to whom it may concern, but I need it to change the "From" field in the e-mail, because there's many people who can send this, but it's looking like it's all being sent as my user. This is the code, it all works, but it doesn't change the sender field. Should I make some sort of auto-login macro or something?
Call fctnOutlook("Reconsideraciones BCH", EmailTasador, Email, , Subjet, "Agradecer revisar la tasacin indicada, de acuerdo a lo pedido en email adjunto, y me des tu opinin. " & vbCrLf & vbCrLf & "Favor no responder a Reconsideraciones BCH, no recibe correos es solo para enos, enviar a visador indicado en el email" & vbCrLf & vbCrLf & "Le saluda atte." & vbCrLf & vbCrLf & usu & vbCrLf & "Seccin Tasaciones" & vbCrLf & "Banco de Chile" & vbCrLf & vbCrLf & vbCrLf, Nz(Tpath), "Yes;No;Maybe", 2, True)
With objMail
.To = EmailTasador
.CC = Email
.Subject = Subjet
.Attachments.Add (Tpath)
[code]....
View 2 Replies
View Related
Mar 5, 2013
I am working on a personal expense ledger. On a particular field that is labeled [expense/income], and a field labeled [amount]. the [expense/income]field is a listbox field "with expense and income as the values. Here is what i want to do. when i select income from the listbox i want it to sum the total in the amount] field, and if i select expense i want it to subtract the total in the [amount] field. i hope i explain it correctly.
View 4 Replies
View Related
Jun 8, 2013
I need to export my reports (invoices) to rtf format or pdf then create seperate emails for each report with email subject title of [Address] [Suburb] [Supervisor]
I also need it to only create them but not send them, as I also need to attach photos and forms prior to sending them.
Is this possible to do in access?
It was so much easier when I could just run the saved export button & drop the 1 file into email.
View 4 Replies
View Related
Oct 15, 2013
I have this code below its giving me the RUntime 2295 error. Unknown message recipients. I have check all email addresses and they are fine. Everything else works except when it gets to Outlook and do not send email. I did a Debug Print but didnt understand how to do it.
Private Sub Command9_Click()
Dim rst As DAO.Recordset
Dim strEmailAddress
Set rst = CurrentDb.OpenRecordset("T_Inspectors")
Do Until rst.EOF
[Code] ....
View 2 Replies
View Related
Nov 20, 2013
i have a database which has new customers added daily (currently we post all documentation)
when a new record is filled in the customer receives:
cover letter/invoice(report), book page(report) and a book (pdf, always the same) the reports are created from the record
rather than post all these documents i would like to email them to each customer in 1 email with the reports in pdf format.
Example:
CC (email feild from the record)
Subject (pre filled with "Stop Bullying Now! Books 4 Schools order")
Body (pre filled with "Dear ([Contact]if possible) Please find enclosed your documentation for your recent telephone order bla bla bla and our logo.jpg if possible)
then i would like to attach to the email the cover letter/invoice(report), book page(report) and the book (pdf) from the hard drive (r.eports changed to pdf)
if i can press a button on the form to send it that would be good.
if i could link it to a query to send a batch of them that would excellent.
The Database is Named: b4s.mdb
The table is called: Main Table
The input form is called: Client
The letter/invoice report is called: b4sletinv
The Book page report: b4sbook
The pdf book is located at c:Documents and SettingsAdministrator4sfinal.pdf
The query for the batch is called: coverlet&proforma
View 2 Replies
View Related
Mar 14, 2007
Hello,
I have done some reading in the forums and tutorial site and thanks to the help of many members here I am learning lots thanks!
My question of the day (Hour :) ) is I have a
ProjectTbl
ProjectID *Defined by user*
Project.StartDate
Project.EndDate
PersonTbl
PersonID *Autonumber*
Person.LastName
Person.FirstName
I have built a form which I can add multiple people to one project but when I look in the table only the person who the relationship was linked to gets the subtable.
Then I researched a Many-Many relationship and this solved that issue, now I can put multiple people on a project and multiple projects on people.
PersonProjectTBL
PersonProjectID *Autonumber*
PersonID
ProjectID
However how do I now make a form where I select a project and associate more then one person with this project?
I think I need to somehow increment the PersonProjectTBL and add to it as I go.
The layout I would like to have is:
Combobox 1: Selects the Project (After Select use a (queary ??)) to load in
Combobox 2 and 3 with people.
Combobox 2: Select a person to load into project.
Combobox 3: Select a second person to load into project.
I dont expect a full answer a link or multiple links is very appriciated, even a search topic of what to look for.
Thank you for your time,
Derek L
View 2 Replies
View Related
Apr 3, 2015
I have two tables, "Summary" and 'POC Information". In the "POC Information Table I have all my Contacts Information (Name, Title, Phone, Email, etc...) and I am trying to assign 2 POCs to each of my multiple projects located in the "Summary" Table. I am using a Form called "JCIDS Tracker Input Form" as the link. So far I am able to assign one POC by a combo box that lists "Full Name", then it autofills the other information...Phone Number, Email, etc... The problem come into being when I want to assign a second POC to the same Project...I can assign a name, but it won't correctly autofill the rest of the information...it just autofills in the information from the first POC that was selected.
View 8 Replies
View Related
Jan 31, 2015
I need to enter workload counts for 10 people, and it is done on a monthly basis. So I have a table of Months (Jan-Dec), a table of names, and a joined table with the months, names and a field for the workload counts.
I would like to make a form where I could select the month and all the names show up so I could go and enter the counts for everyone at the same time. I've attached a diagram to show what it would look like
View 3 Replies
View Related
Jul 15, 2013
At present I have a tblData, a tblPeople, a long union query and a report that displays its results. On a form I select a person from tblPeople (another field on that table contains their email address), run the query and report in that person's respect and email the results to them.
What I want to do is add a button which runs some VBA code which cycles through tblPeople, runs the query for each person, works out if the query has returned any records from tblData for that person, and if so - sends them the report.
I am using Access 2010
View 4 Replies
View Related
May 30, 2014
A user reported that when exporting a list of people from a query to excel, certain people/records are not contained in the export. I took a look (old db mdb v2002-2003 access) and what I found was quite odd.
First, I opened the resultant xls and the first 25 rows or so are blank - which I thought was weird - were these the missing records?
Next I noticed that I forgot to close the xls when rerunning/testing the export using this:
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryemailods", Me!Premiername, 0
When I was watching the open spreadsheet, I noticed that it was repopulated with records (I actually expected to get a 'file in use' error, but access carried on) replacing the data.
But lo' and behold! All the records were exported, including the 25 or so missing records at the top where the blank rows previously were located!?!?
I tried a few things... compact and repair on the front and back end of the mdb. Save at newer version of access (2007/accdb), even working locally in case there was some network lag or other issue... Same story... when running the export with the target file closed, the first ~25 records are dropped - but if the xls is already open it runs fine.
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryemailods", Me!Premiername, 0
...and that does in fact produce the proper listing without missing records (with target file closed), but the "12" export causes the following message to pop up when opening the file:
"The file you are trying to open [filename] is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source etc etc etc.. Do you want to open the file now?"
If I hit yes, the file opens and looks good - but why the error message?
View 1 Replies
View Related
Jan 27, 2014
I have a DB with 3 tables;
1) Customer details (address, phone etc)
2) Equipment they have
3) Service History
So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details).
This works well unless I tick 2 box's. I then customer details, equipment & Service History get jumbled up and isn't record specific.
View 3 Replies
View Related
Jul 16, 2014
I have made a query with the name "Confirmation" and it is setup like this:
Name trainee Email Training
John John@mail.com Tr one
Mary Mary@mail.com Tr two
I also made a button in a report with the title "Send Mail" now is my goal that if i press that button automatically multiple e-mail message's will be generated with data from people in that query. So if click on that "Send Email" button i want two different mails messages generated that will be send to John@mail.com and Mary@mail.com with in the mail body their data.
View 13 Replies
View Related
Nov 4, 2004
I have looked through the forums for an answer to a problem I am having,
but I can't seem to find the complete answer.
I just started work on an inventory database that was made by other people;
it is a fairly large database. One of the forms is for equipment maintenance
and in it, you fill out several fields. What needs to be done is an email sent
out to 2 people in the department; they are selected via a combo box and this
runs a query that fills in a table with the proper email addresses and matches it
to the proper job in the table. A due date is inputted in a standard text box.
The emails are then supposed to be sent out on the due date provided.
For some reason, there is no code at all (that I can find) that even runs Outlook,
although it supposedly worked a while back. I have read that timers would help
with this, but I am not quite sure where to go with it. Also, does the email have
to be sent from the person that is logged into Outlook at the time the email is sent,
or can it be sent under another email address no matter who is logged into Outlook
at the time.
Any help would be greatly appreciated.
Thanks
View 12 Replies
View Related
Aug 14, 2014
I have inventory database, in database there is "NextScheduledMaintenance" field, I want access to send email automatically when scheduled maintenance date due.
View 1 Replies
View Related
Jul 8, 2015
I need to know if possible to create multiple queries or reports at the same time. We have large table that is updated monthly this report gets broken down manually by Manager (30 managers in total) hen email to each manager.
Report or query specs will never change only the data I could do this manually create and save query/report for each manager once but I was wondering if there was code that will create all the queries and reports at the same time.
View 1 Replies
View Related
Jun 2, 2014
I have a query (Access 2007) that contains a field named "email" (which contains email addresses, of course). I want to email everyone in the query and they are all going to receive the same message. My email to them doesn't have to be personalized and I don't need to collect data from the recipients. I don't even need a reply to the email I send.
View 12 Replies
View Related
Jan 21, 2014
I have a database that I can use to create a query, grouping companies by city. I then want to send a specific email I have created in outlook to all of the email addresses in the query.I do not need to include names.
View 6 Replies
View Related
Aug 13, 2014
I have inventory database, in database there is "NextScheduledMaintenance" field.
I want access to send email automatically when scheduled maintenance date due.
View 7 Replies
View Related
Oct 18, 2013
I am setting up a database to track preventative maintenance required for testing equipment in our repair shop. Some of my associates would like to be able to send e-mail notifications via the database when maintenance is due. I set up a query to show the people who need to receive an e-mail and a query to show the maintenance each person needs to perform.
Each person will need to perform more than one maintenance step each time. I would like to get it so that the database will loop through the first query and generate one e-mail for each person. I would like the e-mail to list all the steps that person would need to do (as shown in the second query). I know this would require setting up loops and I'm afraid I'm not very good at writing loops.
I think this will need two loops. One to loop through the first query to see all the e-mails that will need generated and one to loop through the actions to be included in each e-mail. The person's name is included in both queries and can be used to set up a link between the two.
View 5 Replies
View Related
Jan 12, 2006
Hi all
I've got a db system linked with webpages that handles rent management and i'd like to set up an email reminder every thursday to tell the student tenants to put the rubbish out for the bin man. I have their email addresses in one table and another table telling them whether its recycling or landfill rubbish.
Basically the question is how would i go about getting access to send the email at a certain time and date ?
Many thanks
View 6 Replies
View Related
Jul 22, 2015
I am trying to create a form button that will automatically email each row of a query result to myself. At first the VBA code worked fine with a standard query. However when I use it with a query that contains a reference to a combobox form such as "<=[Forms]![Reminder]![Monthsleft].[Value] And >=0" I get the 3061 run-time error and "Too few parameters. Expected 1." I have included the VBA code below.
Private Sub Command9_Click()
Dim MyDb As DAO.Database
Dim rsEmail As DAO.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String
[code]....
If you intend to renew the lease, terms and conditions will need to be submitted for ECC for approval (regardless of changes or not in lease rates). If the terms have yet to be confirmed, it is important to begin the negotiation process as soon as possible with a target to provide the ECC submission at least two months prior to the commencement date of the renewed lease. To ensure sufficient time for ECC approval before the contract expiry date, please prepare the ECC paper and obtain necessary endorsements. Submission details can be found here. The ECC submission template and PSD Questionnaire could be found from this link
DoCmd.SendObject acSendNoObject, , , _
sToName, , , sSubject, sMessageBody, False, False
.MoveNext
Loop
End With
Set MyDb = Nothing
Set rsEmail = Nothing
End Sub
View 2 Replies
View Related
Oct 30, 2006
Can someone please look at this and help me as it does not work? It stops right away at the "Dim olApp As Outlook.Application". It tells me "user-defined type not defined". I have searched the forums and could not find a solution.
Thanks,
RichB
Private Sub Command154_Click()
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application
'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)
With objMail
'Set body format to HTML
.To = "Forms!FrmPersonal!Email"
.BCC = Forms!FrmPersonal!rateremail & Forms!FrmPersonal!rrateremail
.Subject = "AUTO EMAIL REMINDER"
.BodyFormat = olFormatHTML
.HTMLBody = "<HTML><BODY>Blah, Blah, Blah</BODY></HTML>"
.Display
End With
End Sub
View 2 Replies
View Related
Oct 10, 2007
Did you know that when you create an MS Access database, personal information such as your user name and the name of the person or company that the software is registered to is saved and displayed with the database file for others to see. Prying eyes simply goto 'File->Database Properties->Summary Tab' to see your personal information.
The fix is simple goto:'Tools->Options->General' and select the 'Remove PersonalInformation from file properties on save' check box. Next time you save, no more personal information.
Don't believe it? Look at some of the sample databases posted here - :eek:
:)
ken
View 1 Replies
View Related
Nov 24, 2014
I have an Access 2013 database which will generate a pdf report and attach it to an email using the code:
Code:
DoCmd.SendObject acSendReport, "Report Name", acFormatPDF, Nz(To email address, a), , , "Email Subject", "Email body", True
I would also like to automatically attach on the server to this email. Such a file stored such as servernamesharefilename.pdf. Is it possible to do this?
View 14 Replies
View Related
