Email In Snapshot Format And Subject Line
Oct 28, 2004
Hi,
I have been reading all of your post for days now and can't find the answer to my question.
I have however found the answer to one of my programming problems. Thanks to all of you.
I have used Access as a data supplier but this is my first attempt to program in access.
I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.
My question(s) are:
1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.
2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.
Thanks so much for all that you have done already.
Tasha
View Replies
ADVERTISEMENT
Aug 27, 2014
I'm trying to write a line of VBA code (in an existing Access 2010 DB) that changes the Subject Line of all selected emails in my Outlook Inbox to today's date.
View 1 Replies
View Related
Sep 5, 2006
Is it possible to email as attachment a FORM in snapshot format?
I have a form that gets the results of a query. I'd like to send the data displayed on this form as snapshot format. Possible? Any alternatives? Suggestions? Please help, i've looked high and low.
View 14 Replies
View Related
May 25, 2004
Using the access ‘Mail Report’ function, the ‘send’ dialog box comes up to select format… Is there a way to pre-select the snapshot format using code.?
View 5 Replies
View Related
Aug 6, 2004
I have a Macro setup and SendObject is one of the Actions. It is setup to send an existing report. Is there a way to insert a fieldname from that report into the Subject line of the e-mail that is sent? That would be great, instead of having the same subject line for every e-mail, using the date or something like that. Please let me know. Thanks.
View 3 Replies
View Related
Mar 11, 2005
Does anyone know how to put in a file reference number automatically into the subject bar of an email?
This is the code that i am currently using:
On Error GoTo Err_Handler
MsgBox "THIS FEATURE WILL ONLY EXPORT FILES WITH TODAYS REFDATE"
If [CboExport] = "Today" Then
Dim rst As Recordset
Dim db As Database
Set db = CurrentDb
'Create Recordset
Set rst = db.OpenRecordset("SELECT tblAT.FileNr, tblAT.RefDate " & _
"FROM tblAT " & _
"WHERE (((tblAT.RefDate)=Date()));", dbOpenDynaset)
'Check to see if there has been records recorded today
If rst.EOF = True And rst.BOF = True Then
Beep
MsgBox "THERE ARE NO RECORDS WITH TODAYS DATE, REFER TO SPECIFIC DATE."
rst.Close
Set db = Nothing
Exit Sub
End If
'Export query as MS EXCELL
DoCmd.SendObject acSendQuery, "qryTodaysDate", acFormatXLS, company@somewhere.com, myboss@somewhere.com, , "File reference number ?????????"The following file is the latest extract from me as at " & Date & "."
regards, Steve
View 5 Replies
View Related
Jul 14, 2015
I am trying to capture a newly arrived mail in outlook with respective subject line. The below code works for me on 2010 outlook but when new mail arrive in outlook 2013 ,Mrthod Items_ItemAdd do not get called.
Code:
Option Explicit
Private WithEvents Items As Outlook.Items
Private Sub Application_Startup()
Dim olApp As Outlook.Application
Dim objNS As Outlook.NameSpace
Set olApp = Outlook.Application
Set objNS = olApp.GetNamespace("MAPI")
' (1) default Inbox
[Code]...
View 10 Replies
View Related
Jan 8, 2007
Curently run a Send.Object function on a form to retrieve a unique record via a query. I'd like to be able to send a particular field returned by the query to use as the subject title in the email that is auto-created.
The query will only ever be returning a single record but that single record will change each time it is run.
Any ideas people?
Thanks in advance.
View 1 Replies
View Related
Jan 10, 2006
First off, hello to everyone here. I have been using these forums for a couple of months now and they have helped me solve many, many problems.
I've not needed to register before now because everything I needed to find out I was able to find an answer for, so THANK YOU:)
Anyways, back to business............................
I've built a reporting application where the users basically enter details on a form that performs a few lookups to autofill some info and they input the rest.
What happens next is when they submit the 'form', it appends details to a table and sends an email with the details entered to an address specified by a populated text box on the form
One of 3rd party contractors has requested we send this info in .snp format instead of just referencing the textboxes in the body of the mail.
I have created a duplicate of the form in snapshot but cannot figure out how to do the following:
1. Reference the open form to populate the fields
2. Then attach this to the email
Any help would be greatly appreciated.......as I'm tearing my hair out (and I don't really have much left to tear out anyway)
Many thx in adv
View 6 Replies
View Related
Feb 1, 2006
Hi.
I am just setting up a command button so when it is pushed, outlook opens and I can send a message.
The code for this I got from another thread.
I am sure this is a simple one (?) but in the message of the email, I want numerous amounts of lines, not just the one.
This is the code for the message subject (taking from the thread)
strMessage = "Hello" & " " & Me.cboChampion.Column(1)
I want about 10 lines, not just the one. I tried copying the same line again, but that didn't work
I am sure this is basic coding....just can't find the answer.
Hope this makes sense.
Thanks.
Frank.
View 2 Replies
View Related
Mar 2, 2012
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
View 3 Replies
View Related
Mar 27, 2014
When you create a column chart and then change one of the series to a line, how can you then apply formatting to that line? I've attached a stripped down database showing what I'm trying to do. Series 1 shows individual monthly values (percentages) and series 2 shows the target which is 80% for each month.
The problem is that although I can apply formatting to the column series, I can't see any way of selecting the line series so I can set the formatting I want. I'm using Access 2003, on Win XP Professional, in case that's important.
View 3 Replies
View Related
Mar 20, 2014
i'm trying to send an Outlook e-mail from Access. Everything works fine except for one thing:
When generating the HTMLBody I use vbNewLine for starting a new line in the string that works fine as long as being in Access. However after displaying it in Outlook there are no any new lines in the mail text; the complete text is one mass.
I tried to use Chr(13) but had the same result.
View 2 Replies
View Related
Mar 7, 2014
I have set up an access application with a report being exported to rtf format. Would prefer word format if it is possible.
In the export document created there are line breaks on every row. This creates headache when the exported text is re-used in a word document.
is there any way how to have the export where the text is kept together without line breaks on every row?
View 2 Replies
View Related
Aug 31, 2005
I have a button on a form that creates an email and inserts fields from my database. I have a field that is set to Long Date format type, but when it populates the email, it shows as a Short Date format type. Is there anyway to retain the Long Date format?
View 1 Replies
View Related
Apr 11, 2006
Hi,
I am trying to email a table in text format using :
DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts"
It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.
Thx,
Jatz
View 1 Replies
View Related
Apr 11, 2006
Hi,
I am trying to email a table in text format using :
DoCmd.SendObject acSendTable, "Table", acFormatTXt, , , , "Results", "Attached are the reslts"
It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.
Thx,
Jatz
View 2 Replies
View Related
May 23, 2013
I am new to Access. I am using Access 2010. I have searched and found several articles on emailing the current record shown on a form but haven't been able to get any of them to work.
My goal is to have a user input information onto the form and then have one button the user will click that will save the current record, email the current record in pdf, and then close the form.
The form name is: frmCorrectiveActions. The unique identifier for a record is: Corrective Action ID.
The last coding I tried is below. I know something is wrong but have copied this code from another post about emailing forms so I'm not even sure what half of it means.
I am getting the message Run-time error '3075': Syntax error (missing operator) in query expression "Corrective Actions ID = 23' and when I hit debug this is highlighted: qry.SQL = strSQL
form Private Sub Email_Click()
Dim qry As DAO.QueryDef
Dim strSQL As String
Dim ReportQueryName As String
ReportQueryName = "qryCorrectiveActions"
Set qry = CurrentDb.QueryDefs(ReportQueryName)
[Code] ....
View 5 Replies
View Related
Aug 20, 2014
I am using the following vba code to create and send an html format email message. The key information in the email is a hyperlink to a network drive folder location using [Directory] as a hyperlink table value to get the address that is stored like this:
K:PipelinesP9 - TEP ProductsMOP AID-1500Final Approved
The email hyperlink that is produced looks like this:
#K:PipelinesP9_-_TEP_ProductsMOP_AID-
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Dim MOPVDB As String
MOPVDB = "H:PGADSBYMOP VALIDATIONTRACKINGMOPVDBMOP Validation DatabaseFE.accdb"
Set appOutLook = CreateObject("Outlook.Application")
[code]...
View 1 Replies
View Related
Jul 24, 2015
how to properly get my email body to format correctly? I am obviously misusing the .HTMLbody/tags incorrectly. The email generates with the attachments as expected, but the email body message is just runon.
Code:
Private Sub Command29_Click()
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
[code]....
View 6 Replies
View Related
Jul 2, 2014
I'm trying to create a lotus notes email through vba that contains data from one of my access tables. Since I'd like the data to be displayed in a tabular fashion, I'm trying to format the body of the email in html.
View 1 Replies
View Related
Sep 6, 2012
I want to export a table in access table .
1. for example every day at 8.00 it create an output excel file.
2. Attach the file and send to a fixed email at that time.
View 1 Replies
View Related
Sep 9, 2013
I need to send the report using DoCmd.SendObject. However, I need to send it based on each tech's job via email.
Currently all tech and jobs on the reports together. I need it to pull the email address and only send to that tech its jobs.
Currently I'm using the basic vba code
DoCmd.SendObject acSendReport, "R_DispatchInspectors", acFormatPDF, "email@me.com", , , "Job number", "Please see attached", False
However do I allows this to send individual report connected to email address. (Which will have each tech's specific jobs sent to them only).
table name: Inspectors (this one have their email address)
Table name: JObs
Report name: R_DispatchInspectors
View 3 Replies
View Related
Nov 10, 2014
I have a subform in Continuous Records format (records displayed are determined by controls on the parent). I would like to create a button that prepares an email and copies the contents of that subform in to the body of an email message.
The email. I have a method to create a new email, set To, CC, Subject and even Message Text.
Code:
strTo = txtName
strCC = txtManager
strSubject = "Something"
strMessage = "Hi, please find below list of details from X Y and Z" & vbnewline & vbnewline
That all works. Thats fine
The Records: I have found ways to have them added as an attachment, either the the SendObject and OutputTo method but I would like the list of records to be converted to a text string so I can include it within my strMessage variable, not include it as an attachment.
Code:
strMessage = strMessage & "Subform Records to go here"...
View 7 Replies
View Related
Jul 27, 2005
I have posted on a couple of other sites and have not had an answer in two days on a replicated database question. Is this a taboo subject, or is there just not a lot known about it?
I have a FE/BE Database that has 25 users. Two of these users moved offsite and are having huge speed issues. What I have gotten out of my research is the best thing to do is create a replica of the backend and transfer that replica to the offsite agents pc. This way everything is on their C drive instead of the BE being on the network and the only speed issues they will have is when they synchronize the replica w/ the backend.
Here is my problem. How do I create a button on the FE of the Database that will cause the BE on their PC to synchronize with the Design Master BE on the network?
I have a limited understanding of VBA.
Any Help would be appreciated.
Thanks,
View 3 Replies
View Related
Jun 25, 2013
Here's the statement
Code:
sqlfinal = "SELECT Employees.ID, Employees.Name "
sqlfinal = sqlfinal & "FROM ((qryDeptVBA INNER JOIN qrySkillVBA ON qryDeptVBA.ID = qrySkillVBA.ID) "
sqlfinal = sqlfinal & "INNER JOIN Employees ON qryDeptVBA.ID = Employees.ID) "
sqlfinal = sqlfinal & "INNER JOIN qryAreaVBA ON Employees.ID = qryAreaVBA.EmpID "
sqlfinal = sqlfinal & "GROUP BY Employees.ID, Employees.Name;"
If i simply remove the GROUP BY line and stick the semicolon at the end of the previous line (.EmpID; ) it works just fine. How is adding a group by line causing an error?I tried adding another parenthes at the beginning ((( and ending the joins as EmpID); and that failed with the exact same error.
View 12 Replies
View Related
