I have a database which is populated, but users have to review and amend the data. I was going to ask users to sign in to do this, however my boss wants the data collected via email.
I have looked at using the email wizard, but it produces a rather messy looking email form regardless of if I choose HTML or InfoPath. Is there any way to adapt the email to make it better, or maybe another way of emailing users (through VBA)?
as above.
View 6 Replies View RelatedThis is a template under 'sample templates' : "Tasks". it has a button called " Collect data via e-mail". I couldn't test is because when i hit the button it says "microsoft out look could not be started, make sure outlook is installed and properly set up.( the send and receive dialog box in outlook shows is marked and read as complete, but the green bar showing progress is still lit up + calendar contacts,etc. wont sync in mobile device center).
View 2 Replies View RelatedI am using and modifying (very little) the template "Issues and Tasks" to have my team of 35 people submit any feedback that they may have on a particular campaign.
No one has Access except for me....I would like to use the "Data Collect | Create Email" Feature so that whenever they have any issues they can just fill that out (Save the email in a special folder to be used multiple times). The problem I am encountering is that the "Create Email" button is greyed out and I am not sure why....also, I would like to know if this is the most efficient way of doing this.
I have a golf society database. I would like to be able to send, via e-mail, a 'Form' to each of the members of the society so that that they could fill in the data in the form then e-mail it back to me and then import it into the database.
Has anyone got any good suggestions on how I should do this please ?
Cheers
Frank
In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.
View 6 Replies View RelatedI have a parameter query using a form to collect the data. I put LIKE and wildcard enclosing the parameter to bypass the criteria if the data box is empty. It works well. I have another parameter of date type that uses between two dates. How can I bypass the criteria if I leave the data boxes blank?
View 8 Replies View RelatedI created a form for adding new data to an existing database and it worked just fine.
Today the form has decided to add time to the date field and this clashes with the table it import to.
Why/how it's changed the date format and how to change it back?
I am the first to admit I struggle with looping through records.
I am trying to loop through a table and collect external income data and write it to a new table.
My issue may be the way the table is laid out. ???
The attached pictures show the tables. The tblExtInc is where the data are. I am trying to create a table that looks like tblExtIncYr that shows each year and separate entries by item.
How would I loop through tblExtInc and grab ex:$2000 every year for upto 100 years but only get the $1000 for year 6,7,8 only?
My department handles all two-way email communication with our customers. We have 8 different email addresses that we use depending on the customer service issue. I'm looking for a way to continuously collect 3 pieces of data from every email that is received: 1) Date Received, 2) Time Received, and 3) To Field (which of the 8 email addresses it was sent to).
As you can imagine the collection of this data to look for trends to assist with staffing needs, as well as analyze build reports for the company to review. I've been working with my IT department on this but they are not sure where to start. My guess is that I need to have them collect the data as it is coming into the email server, right? I'm good with VB and I've built some VBA scripts recently that collect Outlook information, but these only work if the computer I'm using stays on all the time which is not always practical. We'd like to have this database stored on one of our shared drives which collects this data indefinitely from our email server.
I am new to Access and i send an email to my user's to input the data to their email address.
I would like to know if I can get my "Email address" column automatically updated whenever they send an entry using their email address ?
I have a form which has a button to email the data out in a standard email message.
Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String
[code]...
This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.
I have a database that keeps track of employees absences and tardies but after a certain amount of time is the data valid. I want to be able to type into my text box a date and have the query collect all infromation a year back. I know how to do it if I was just using the current date but how do I pull the information from a date a user can input?
In the date field I have the following:
=[form]![selectdate]![date]< 365
I've even tried [form]![select]![date] - 365
Can someone help me out? :)
'lo all,
I'd like to use a form to get user input on BeforeDate and AfterDate for a query with criteria
<[BeforeDate] AND >[AfterDate]
I must be missing the wood for the trees- how hard can it be?
Thanks for pointing out the glaringly bleedin' obvious,
Alex
Method 'Collect' of object'_Recordset' failed is the error I am getting when I try to set a record field to a form text field that has the system date set to it.
Specifically.
yrst is the recordset
I set a number of recordset fields to values on a form with no problem.
Included on the form is a field "txtNewUpdtDt". The control source is =Date()
The statement that is failing is yrst!SysUpdtDt = Me.txtNewUpdtDt
This had been working until today. I googled the error message and found a lot of hits, but none that specifically addressed my situation.
Anyone have any idea what's going on?
Thanks,
B
I need to handle a code to collect a list of files at specified path to be inserted into one table fields:
file name, extension, date, size...etc
I would like to create a payroll record that collect some information from another table. In other words:
-I have an employee.
-I have a payroll table.
-I would like to get some of the values from the employee table written to the payroll table when a new record is entered.
The form would look some thing like this:
Three boxes:
Employee: [ ] (table query to find name) # of students [ ] #of class minutes [ ] (value list with 3 choices)
When the SAVE button is pressed a record would be written to the payroll table with:
The payroll table would look like this:
payrolid#, employee#, employee, # of students, # of class minutes, rate, date
The employee#, employee and the rate would come from the employee table.The # of students, # of class minutes and date would come from the payroll form.
In my database I have a table for all of the customers emails which list the 3 titles for each district they serve, for example District 1 has across the President, Vice President and Clerk. each email is a hyperlink that when clicked once automatically takes you to outlook, however, how can I choose all 3 at once without having to go back and forth to the database and outlook after the one click? so all 3 recipients are included in the email at once. In Excel you can copy and paste the 3 emails but in Access it doesn't allow you to do that. How I can execute this?
View 5 Replies View RelatedI have an Email field on a form. Is it possible to send an email by clicking on the email address? Now, I only have a vague familiarity with VBA as I've taken an Access Intermediate class. We were just introduced to it at the end of the class, so you may have to walk me through it like a 6 year old. I went to a site that said a macro was needed in either the After Update, After Delete, or After Insert. With that said, I know where to go, but I don't know exactly how to write the code. I have outlook set up on my computer and am operating Windows 8.1 and Access 360.
View 5 Replies View Relatedmy html template is built inside access.. the form button is clicked and the template opens in outlook.
it looks fine in outlook.. so i send the email.. when i receive the email in outlook, it looks fine..
here is what it looks like
http://www.londonheathrowcars.com/image2.jpg
however, i sent the same template to a gmail and hotmail address to see what it looks like..
it looks fine in hotmail
http://www.londonheathrowcars.com/image3.jpg
however in gmail it looks like this..
http://www.londonheathrowcars.com/image1.jpg
now, these gaps are appearing in between tables..
<table>blablabl</table>GAP<table>...
now, my question is.. is there anything i can add to the code that will remove these gaps..
i know my code is messy.. at the moment however it begins with <table> and ends with </table> (the main wrap table)
i realise i may need to add some kind of html type or something, but i dont know what..
as always, if anyone can shed some light on this matter i would be ever grateful..
thank you
below is the code
CODE
Option Compare Database
Private Sub emailbutton_Click()
'References: Oulook Library
Dim strEmail, strSubject As String, strBody As String
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)
strEmail = Me.emailadd
strBody = "<table border='1' width='610' id='table1' cellspacing='0' cellpadding='5' bordercolor='#5A79B5' align='left'><tr><td align='center'><table border='0' width='600' id='table2' cellspacing='0' cellpadding='0'>" & _
"<tr><td width='300' height='61'> </td><td width='300' height='61' align='center'><img border='0' src='http://www.londonheathrowcars.com/emaillogosmall.gif' width='300' height='61'></td></tr><tr><td width='300' height='30'><font size='2' face='Arial' color='#000080'>FAO</font></td>" & _
"<td width='300' height='30' align='center'><b><font face='Arial' color='#5A79B5'>-------- London Heathrow Cars --------</font></b></td></tr></table><table border='0' width='600' id='table3' cellspacing='0' cellpadding='0'><tr><td> </td></tr><tr>" & _
"<td><font size='2' face='Arial' color='#000080'>Thank you for your booking request via our website.<br>Details of the requested transfer and our fare are as follows:</font></td></tr><tr><td> </td></tr><tr><td><hr color='#5A79B5'></td></tr></table>" & _
"<table border='0' width='600' id='table4' cellspacing='0' cellpadding='0'><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Job Date:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Pickup Time:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>From:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>To:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'> </td><td width='400' height='20'> </td>" & _
"</tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Vehicle:</b></font></td><td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr><tr><td width='200' height='20'><font size='2' face='Arial' color='#000080'><b>Set Fare:</b></font></td>" & _
"<td width='400' height='20'><font size='2' face='Arial' color='#000080'> This</font></td></tr></table><table border='0' width='600' id='table5' cellspacing='0' cellpadding='0'><tr><td><hr color='#5A79B5'></td></tr><tr><td> </td></tr><tr><td>" & _
"<font size='2' face='Arial' color='#000080'>Our drivers are courteous, experienced and smartly presented. In addition, all of our vehicles are modern, clean and comfortable. To book this transfer, kindly reply to this email or call us on the following:</font></td>" & _
"</tr><tr><td> </td></tr><tr><td><table border='0' id='table9' cellspacing='0' cellpadding='0'><tr><td width='150'><b><font face='Arial' size='2' color='#000080'>Freephone (UK Only):</font></b></td><td width='150' align='left'><b><font face='Arial' size='2' color='#000080'>" & _
" 0800 505 3231</font></b></td></tr><tr><td width='150'><b><font face='Arial' size='2' color='#000080'>International:</font></b></td><td width='150' align='left'><font face='Arial' color='#000080' size='2'><b> +44 (0) 208 814 2727</b></font></td></tr></table></td>" & _
"</tr><tr><td> </td></tr><tr><td><hr color='#5A79B5'></td></tr><tr><td><b><font size='2' face='Arial' color='#5A79B5'>Hasan Karim - Operations<br>London Heathrow Cars<br> </font></b></td></tr></table><table border='0' width='600' id='table10' cellspacing='0' cellpadding='0'>" & _
"<tr><td><table border='0' width='325' id='table11' cellspacing='0' cellpadding='0'><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Address:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'>" & _
" Suite 7, Jolyon House, Amberley Way, TW4 6BH</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Phone:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'> +44 (0) 208 814 </span>" & _
"<span style='font-family: Arial; font-size: 8pt; color: #5A79B5'>2727</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Fax:</span></font></td><td width='250'><span style='font-size: 8pt; font-family: Arial; color: rgb(90, 121, 181);'>" & _
" +44 (0) 208 399 6500</span></td></tr><tr><td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Web:</span></font></td><td width='250'><span style='font-family: Arial; font-size: 8pt; color: #5A79B5'> http://www.LondonHeathrowCars.com</span></td></tr><tr>" & _
"<td width='75'><font face='Arial' color='#5A79B5'><span style='font-size: 8pt'>Email:</span></font></td><td width='250'><span style='font-family: Arial; font-size: 8pt; color: #5A79B5'> info@LondonHeathrowCars.com</span></td></tr></table></td></tr></table></td></tr></table>"
strSubject = "London Heathrow Cars - Booking Request"
With objEmail
.To = strEmail
.Subject = strSubject
.HTMLBody = strBody
'.Send 'Will cause warning message
.Display
End With
Set objEmail = Nothing
End Sub
Using Access 2010, I have a table the contains a field, MembereMail, that is defined as a hyperlink. I imported data from an Excel spreadsheet which looked to be consistent in format and did not realise that anything was wrong until I wrote some VB code to generate personalised emails with personalised attachments. I then found that some of the hyperlinks worked and some didn't. Those that were essentially text worked, those that were genuine hyperlinks tried and failed to go to addresses prefixed "Mailto:".
I have finally managed to convert all email hyperlinks to text content (although still defined as hyperlinks) and my code works. However when I add a new record to the table through a form, the field still being defined as Hyperlink, it goes in as pure text. I therefore have the need to use the address in both text form and as hyperlink so that the user can click on the field and start an Outlook email as well as my code running correctly for mass mailings.
So a number of questions:
-Why does Access not store the email address as a clickable Hyperlink?
-How can I satisfy my two requirements from one field?
-Can Access 2010 check the input text to ensure that it is a correctly formatted email address?
I love all the email post information that is available, but I haven't been able to find exactly what I am looking for...
Suppose a customer enters a computer workorder request. Then upon completing the form, your boss wants it to automatically send your office an email "your.office@here.com" and the requester's email (which it would get from email field the customer just entered their request into). The boss wants it to also include in the subject line "Workorder #" and then the workorder autonumber that was assigned to that workorder request. The boss also wants certain information inside the body of the email... ProblemType, Description, Remarks & LastName.
This should be sent automatically without the "customer" knowing or having to interact with outlook in anyway (if possible).
Thanks!
I want to automate the distribution of individuals Vacation Balance and Usage via email. The data is being pulled from 2 tables related by an Employee ID#. tbl-Employees provides the Header Info for each employee and tbl-VacLog provides the detailed Usage data.
I want the output to appear as follows in the body of the email:
Name Start Date Vac. Bal TotVacToEOY Personal Bal.
John Doe 1/1/99 120 160 8
Usage Date Hours Reason Code
1/1/13 8 V
2/15/13 12 V
3/6/13 8 V
I've got a handle on creating the email and sending but where I'm having trouble is in making the link between the two tables with the Employee ID# and printing the corresponding detail data with Parent Record.
Code below...
Option Compare Database
Sub SendMails()
Dim DB As Database
Dim RecordSetA As DAO.Recordset
Dim RecordSetB As DAO.Recordset
Dim TotalRecordsA As Integer
[Code] .....
If I send an HTML message to an individual and they reply back on Monday, can they still reply again on Tuesday to the same message and again on Wednesday, so on and so forth? Will this be adding multiple records to the table?
Also, please consider the same situtation for an InfoPath email. Thanks.
Chris
I have a database where I keep track of student employees. The database has three forms, a new hire form, a supervisor form and a financial aid form. The student fills out a new hire form that requires additional input from the hiring department and from financial aid. Included on the new hire form is the name of the supervisor. I have a table that contains the supervisor name as well as email address. Once the student has filled out the new hire form, I would like to generate an email that sends a report, identifying the new hire, to the supervisor requesting them to fill in the missing information in the database. I want the email to either (1) be generated automatically once the student has completed the form selecting who to email to form the student input or (2) have the student pick the supervisor from a list to send the email to. I have very limited knowledge of programming. Thanks.
View 3 Replies View RelatedI 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