Automated Email Report
Mar 24, 2006
I have set up a process to automatically email reports from MS Access 2006. Everything would would perfectly except that when the process runs, a messagbox pops up stating that 'an unknown prgram is trying to send an email on your behalf'. Before the email is sent you have to click on the button to allow sending. I need this program to run very early in the morning when no one is around to click the button.
I have tried several things to get a round this by digitally signing my Access project and setting up certificates in outlook but nothing has worked.
Is there any way around this without lowering my security level, my antivirus or antispyware software?
Thanks
GEM1204
View Replies
ADVERTISEMENT
Jan 8, 2015
Every month I have to make a report about registration of hours of a group of employees. (These employees have a deal with direction about travel hours vs. working hours).This report has to be send to the group members but only the data which is valid for the group member in it. There are 11 persons in this group so I have to send 11 reports.
I made a query with the hours registered from this group. I couldn't export it because it was read-only. That was because the query contains joins to the employee table. After that I tried it with a report. That nearly went well but it contained all data and not the seperated info.What I need to know:What is easier/better: use a query or use a report?Is there code which looks in my query or the report and makes it into seperated reports?I've tried the code of Tony Hine but I can't make it work.After that I need to do a mail-merge. But first of all do I need to make the seperated reports to work.
View 6 Replies
View Related
Jul 16, 2015
Is there a way to have my database see that its a new month and then run a report that could be automatically emailed?
View 6 Replies
View Related
Aug 3, 2015
I have an automated email system (Lotus Notes) in a Access database I have created and am looking for the code needed to add up to 3 c.c addresses into an email prior to sending automatically.
The code I have to send the email to the To: individual is all working but what code I need to add and where for the c.c addresses of which there could be 1, 2 or 3. The control for To address is EmailTo = CustCopyEmail The controls for the 3 c.c emails are cc_EmailAddress, cc_EmailAddress1 and cc_EmailAddress2.
Here's the code I have:
Private Sub SEND_CC_Click()
' Set up the objects required for Automation into Lotus Notes.
Dim Maildb As Object 'The mail database.
Dim Session As Object 'The Lotus Notes session.
Dim MailDoc As Object 'The mail document itself.
Dim UserName As String 'The current users Lotus Notes name.
[code]....
View 8 Replies
View Related
Jan 14, 2015
Is there a way to send a standard ready made email to a set email address when a check box or selection from a combo box is selected.
What Im hoping to have is an action and if a user select a specific action it sends out an email without having to do this repeatedly and manually.
View 2 Replies
View Related
Mar 6, 2012
I have inheirited an access database which used to mail out an attachment automatically but for some reason has stopped sending.
View 1 Replies
View Related
Dec 7, 2011
How can I send an automated email notification everytime a new record is created. I have a macro set up with the send object completed, I just can't figure out how to tweak the logic so it will do it everytime a new record is created.
View 5 Replies
View Related
Sep 30, 2013
I want to automate a task in access....
I have a query that may have 6 - 7 different records for example each record contains a different email address, i need to get the first email then send and email to that address then go to the next record get that email address send an email to that email address until its gone through all the records...
I use this code to send an email, dont know how to loop through records and get the email...
Code:
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Dim strPath As String
Dim strFileName As String
Set appOutLook = CreateObject("Outlook.Application")
[Code] .....
View 1 Replies
View Related
Aug 30, 2006
I have a multi-layered question regarding setting up an access database for fluid samples sent in by a customer.
Ideal Setup:
The database would prompt me for the Sample ID number which is a unique code we give to each sample. It would then prompt me for the customer name and if given an existing customer name it would pull up all the contact information for the customer. It would then prompt me for the machine ID# that the sample came from, from which it will pull up the data from 10 previous reports and place into the current report.
I would then input the current data for the sample after analyzing it. I then have an automated control to convert the report to a .pdf file and send it via outlook. It would also be nice if the report was uploaded onto a website that the customer could access, but this is a whole different issue.
Is this setup possible with Access 03 and if so is it even remotely possible for a newbie like me to create? Additionally, what would the time investment be for a project like this for a beginner? Are there any other more effecients ways or programs to accomplish this level of automation?
Thanks for any help you might lend!
View 1 Replies
View Related
Jun 11, 2015
automated per-record report distribution. In my system there is a report generated with a record for every person that must be sent out to them on a periodic basis. Ideally I would like to send them out in batch(5000+ records) so that each person receives theirs via E-mail. I am not too worried about the format. Each persons record contains their E-mail address so that should make things easier.
View 2 Replies
View Related
Dec 23, 2004
Does anyone know what code or macro you could use to automatically zoom a report to "fit" the screen in the print preview state? Thanks in advance for any help!
View 2 Replies
View Related
Jun 11, 2007
I have a report that I'm looking to email as opposed to fax. What's the easiest way to achieve this?
Any and all advice appreciated.
Thanks!
d
View 9 Replies
View Related
Feb 24, 2006
I have a form with a subform. The form is the date field. The subform are all the stores delivered to on that date. I need to have a command button to open an email with the current date showing and list all the stores with their delivery numbers next to it inside the email.
View 2 Replies
View Related
Dec 21, 2004
Access 2003
Is is feasable to output a report with variable data to html/email. I would like to be able to send my quotations and invoices via email to my customers as many are now requesting I use email. At present I have to print it as PDF then open Outlook, then attach the PDF document etc etc.......
Any assistance or suggestions greatfully welcomed.
sjh7225.
View 1 Replies
View Related
Jul 16, 2005
After filling in a form which includes both text and a photograph (in a bound object frame -- different photograph (OLE object) for every form -- photographs embedded and pulled from a separate photograph file external to MS Access) I email the corresponding report successfully as a .snp file attachment. The problem is that the recipient needs either MS Access or Snapshot Viewer installed in order to view the photograph field (ie. the OLE object in the bound object frame). If I try to format the report according to any other format (html, rtf, etc.) the text shows up okay but the photograph doesn't appear in the bound object frame. I also tried to create a data access page but the OLE 'photograph' field is not even an allowed selection. Any ideas on how I can get around this problem (ie. email the report to a client who doesn't have MS Access or Snapshot Viewer installed on their computer)?
Thanks ahead of time .....
View 3 Replies
View Related
Oct 7, 2003
Hi,
I would like to ask a question regarding MS Access reports. I used the following code to email the report created in Access.
DoCmd.SendObject [ObjectType],[ObjectName],[OutputFormat],[To],[CC],[BCC],[Subject],[MessageText],[EditMessage],[TemplateFile]
I send a report in an email in rich text format and it works. But when you open the report there is no image, lines or rectangles. The format is ok but image on top of the report and lines are missing which I used for column captions. If anyone know how to handle this problem, I will really appreciate.
Thanks
Naveed
View 5 Replies
View Related
Nov 8, 2007
Hello,
I have my email code working great, but I am trying to find a way to add a report as an attactment on the email.
I am using the following and it works fine.
Code:Set objMessage = CreateObject("CDO.Message")objMessage.Subject = EmailSubjectobjMessage.FROM = UserEmailobjMessage.To = EmailToobjMessage.TextBody = EmailBodyobjMessage.AddAttachment "c: emp
eadme.txt"objMessage.Send
How can I go about having that AddAttachment run and attach a report in the same database? I tried a few different ways of putting the report on that line but nothing seems to be working. Do I have to first have code run the report and export it or save it off as something to a temp file then attach it? If so how would I go about doing that. : )
Few things I tried and didnt work..
objMessage.AddAttachment Reports.rpt_01
objMessage.AddAttachment Docmd.OpenReport ("rpt_01")
Any help, ideas, or direction would be great! Thanks!
View 1 Replies
View Related
Jul 17, 2013
Using Access 2007 and Lotus Notes 8.5 ...I've got some code to output a report to email as an attachment: it looks like this
DoCmd.SendObject acSendReport, "rep09emailnotification", acFormatRTF, "(Recipients)", , , "email subject", "email body text", 0
For MOST of the people who use the database, this works fine, and they send the email with the RTF attachment which all the recipients can open - but for some users, it generates a .tmp file which if you 'Open' it is just a load of gobbledegook, but it you 'View' it looks ok - but is truncating the report.what could be causing Access 2007 to create .tmp files rather than .rtf?
View 5 Replies
View Related
Jul 14, 2015
I am trying to email a report and rename the report after the referenced NCR# currently selected on my form. My codes works for putting the referenced NCR# in my email subject, but I am having issues renaming the report and the error is with the SetProperty line bolded below. When I click my email button, I get Run-time error 32004: The control name "Supplier Chargebacks" is misspelled or refers to a control that doesn't exists.
Private Sub Command587_Click()
Dim stReport As String
Dim stWhere As String
Dim stSubject As String
Dim NCRNum As String
NCRNum = Forms![NCR Input Form]![NCR #]
[Code] .....
View 5 Replies
View Related
Sep 29, 2005
Hi Guys,
Im new to access and i have a problem!! I have a report that i need to be sent out monthly to 3 people. The problem is i dont know where to start. I have been looking through the forum, but nothing that i can get my head around, so there anyone out there who can help???????
Thanks in advance!!!
View 3 Replies
View Related
Dec 19, 2006
Is there a way to have access remember a certain time like 2:00 pm and generate a report and send it to a specific person. I know how to make an attachment for sending someone a report but how do I get access to do it on a certain time lets say 2:00 PM?
View 1 Replies
View Related
Jan 20, 2015
I found the vba to generate multiple pdf's from a single report which is working well (see below).
The script below generates about 15 pdf files and stores them in the specified directory
I'd like to be able to now email these to the individual users (SCNAME) but cannot work out where to start, i've tried a lot of things from the research on emailing, just not working.
All the information I need is in one table which includes the users email address field (SCemail).
I've also created an update query which generates a unique file name into the field (SCInstallDate) (currently not using this field data)
Code:
Private Sub cmdSC2PDF_Click()
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("SELECT DISTINCT [SCNAME] FROM [Schedule];", dbOpenSnapshot)
Do While Not rst.EOF
strRptFilter = "[SCName] = " & Chr(34) & rst![SCNAME] & Chr(34)
[Code] .....
View 14 Replies
View Related
Apr 3, 2014
I want to be able to email a report to several individuals and have only the data that pertains to that person attached in the email? Is this possible?
View 1 Replies
View Related
Feb 11, 2015
I have a button setup to email a Proposal Report to specific people. Works fine. I now need the ability to email the Proposal Report (without an addendum) OR email the Proposal Report with an addendum. There are additional fields on the report with an addendum. I have tried the on format event of the Proposal Report to make the addendum fields invisible using this if statement:
Code:
if Forms![CurrentJobs]![Addendums].Form![AddendumNum] Is Null Then
Me.AddendumNum.Visible = False
Me.Label324.Visible = False
Me.Label325.Visible = False
Me.AddendumDrawings.Visible = False
Me.AddendumDrawingsDate.Visible = False
Me.Label326.Visible = False
Me.AddendumFloors.Visible = False
Me.Label327.Visible = False
End If
But I keep getting an "object required" error. how I can run the Proposal Report with or without addendum information depending on the job?
View 6 Replies
View Related
Mar 5, 2006
Hi
From advice I have read on here I have worked out how to create a button on a form which opens a report to show the values which match the record open on the form. It then attaches that page as a txt file to an email. Which is great.
What I would like it to do though is insert into the body text of the email the text from the report. Have looked as much as I can at the properties of DoCmd.SendObject acSendReport but cannot achieve this myself.
What I have is pretty much this:
Code:DoCmd.SendObject acSendReport, "Your matching details this week", acFormatTXT, Me!PersonEmail, , , "Details this week " & Date, "Please see the attached text file for details this week which match your selection criteria.", False
How can I make the text appear within the email body?
View 14 Replies
View Related
Apr 14, 2014
I have a report that creates purchase orders, this could be many suppliers these suppliers have e-mail addresses.
is it possible to get the report to look at the supplier name , find the e-mail for that supplier and send it to them.
View 1 Replies
View Related