Emailing From Access Database Via Outlook
Mar 13, 2006
Please help! I wish to set up an access database from which I can email mutiple contacts at once. I would like to send a pretty HTML message and, if possible automatically address each email personally, i.e. Dear John rather than Dear all.
I have experience with access but not sending emails from records stored in a database. My visualbasic is um...basic, but I can understand it if you're kind enough to explain in simple terms! Your advice would be most appreciated - I need ease of use and most importantly the personal touch of addressing each email to the individual.
Thanks! Look forward to a reply!
View Replies
ADVERTISEMENT
Jan 19, 2007
Hi to all!
I dont know if this is possible but can someone please suggest if this is possible and if so where I could find some info on how to do it or what I should be looking for in this group.
Can I set something up so that I can email from Outlook to all the customers in the query below?
I have an access database which I have creatged a query that pulls results from a table with 100 customers in it.
Lately I have been cutting and pasting information from the database and email every customer individualy.
An example would be as follows.
------------------------------------------------------------------------------
Dear JOHN,
Your listing with us contins the following results...
CAT
DOG
MOUSE
Your listing has been viewed 10 times.
------------------------------------------------------------------------------
The text in capitals are results from three colums in the database.
Colums are called
Name: JOHN
Email:JOHN@THEPETSHOP.COM
Result: CAT, DOG & MOUSE
Search Result: 10
Can I set something up so that I can email from Outlook to all the customers in the query above?
Where can i look to learn how.
Cheers
Mally
View 1 Replies
View Related
Jan 18, 2015
I use the below code to open an access database, but it opens for a second and then closes. When I run the same code from excel, it works OK.
Code:
Sub OpenDatabase1()
Dim LPath As String
Dim LCategoryID As Long
[code]....
View 6 Replies
View Related
Dec 18, 2013
I have a contact form on our website which sends an email to the business dev team saying that the user has requested to be sent product sheets. The email contains the users name, email, phone number, and a few other fields. Is there a way I can send the details of these emails to my access database automatically?
View 9 Replies
View Related
Oct 24, 2012
I need to let all our suppliers know we have moved and wanted to do this by email. how I use Access database of suppliers email addresses and use them on Outlook.
View 1 Replies
View Related
Nov 21, 2013
I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.
View 2 Replies
View Related
Oct 22, 2014
I have a database with my staff in. If they are car drivers I take not of their Insurance and MOT renewal dates. I have built a query that gives me a reminder date ten days before and 5 days after the renewal. I also have an email function that emails my administrators the dates of these. Is there a way of getting the database to email specifically on those dates. I.e. a reminder 10 days before and a check 5 days after?
View 3 Replies
View Related
Nov 24, 2005
I have a field within a table called E-Mail. I want to send a newsletter to everyone withing the DB. I have created some code which is as follows:
Private Sub testemailer_Click()
Dim rsEmail As DAO.Recordset
Dim strEmail As String
Set rsEmail = CurrentDb.OpenRecordset("QryStoresEmailticked")
While rsEmail.EOF = False
strEmail = rsEmail.Fields("E-mail").Value + ","
DoCmd.SendObject acSendNoObject, , , "jo.bloggs@k-n.com", , _
strEmail, _
"UK KNLogin NewsLetter", , True, ""
rsEmail.MoveNext
Wend
Set rsEmail = Nothing
End Sub
Now this works but it opens an individual email per email address into the BCC part. That a major problem if you have over 1000 contacts to send to. How do i get all my email addresses from my DB into the BCC of an email?
Any help would be much appreciated!
View 1 Replies
View Related
Jan 30, 2006
Hello, I am looking for some help on what appears to me to be a very large problem. Hopefully, to others, it's an easy fix. I have a very large database that has several details, of which one is email address.
My report is structure to group first on the email address, 2nd on the cost center, and third on the exeption. I am emailing the report to each individual email on the report. I can get it this far, what I can't get is for the email to only mail out each part of the report that is strictly for that particular email address.
I know this isn't very clear, but right now the entire report goes to each email address, I only want specific pages to go. The kicker to it all is that if I set specific parameters the first time, then I would have to set them every time, because the report varies in length each time it is pulled.
Please helppppppp! Thank You
View 5 Replies
View Related
Apr 9, 2006
Hi all i have a delemma
Im building a database that is required to send out a email once a week to selected parties informing them of what items will go out of date this week.
The main problem im trying to over come is the Automatic email.
Any help would be greatful
Mike
View 1 Replies
View Related
Mar 29, 2007
We are a facility maintenance company that do a variety of jobs for many commercial companies with a several different trade groups we have (electrical, hvac, plumbing, painting, masonry, etc...) Our Trade Group Managers submit estimates and budgets for the jobs they are bidding to. I created a database to store all those jobs so we can track what manager has bid to any certain job, what trades are involved, if it has been accepted-rejected-in progress-and such. As of now the managers turn a written (paper) form into me to submit an estimating inquiry request and I put it in the database and print them out a receipt of all the information they submitted to me along with an Inquiry Number (which is the primary key in the database)-then that is how we keep track of that particular bid-with that unique Inquiry Number assigned to it.
Now we are wanting to be able to have this all electronically. So the managers can submit an inquiry request electronically and get a receipt back electronically-either by email or online or whatever. On the form they fill out there are several different trades that are able to be checked off. After they are finished filling out the form I would like for there to be a button at the bottom to email that form to all the checked off trades. How do I go about doing that?
..any suggestions would be greatly appreciated.
Thank you so much!!
View 2 Replies
View Related
Aug 27, 2007
Hello,
From the searches of this site Ive got it down and working to send an email with attachment via access. Thanks
The one thing I cant find is how to change the "From". I don't want these emails send via my name but my department. I usually just change the <From> to the department name in Outlook and send.
I cant seem to figure out how to make it work in access.
FYI: I did it via a module
With objMailItem
.To = "emails"
.Subject = "subject"
.Body = "text"
.Attachments.Add "C:file.xls", olByValue, 1, "department report"
.Save
.Send
needless to say .From does not work.
View 2 Replies
View Related
Aug 29, 2014
I am trying to automate the process of sending a query result via email.
I have code that will export a query as an excel document, using DoCmd.SendObject, but it has the name of the query.
DoCmd.SendObject acSendQuery, "Dailyrpt", acFormatXLSX, email.address, , , "Daily Report", "This is today's report", -1, False (email.address would actually be the email address it is being sent to.)
I also have code that will export the query to excel and save it as a file, using DoCmd.OutputTo, where I was able to name it something meaningful to the end user, and include the date.
DoCmd.OutputTo acOutputQuery, "Dailyrpt", acFormatXLSX, "Z:FolderComplete as of " & Format(Date, "yyyymmdd") & ".xlsx"
Dim Foldername As String
Foldername = "Z:FolderComplete as of " & Format(Date, "yyyymmdd") & ".xlsx"
Shell "C:Program Files (x86)Microsoft OfficeOffice14EXCEL.exe """ & Foldername & "", vbNormalFocus
Is there a way to either send the saved (renamed) file or to include the current date as part of the SendObject command?
View 4 Replies
View Related
Jul 18, 2013
i am very new to access, but i can code in excel well.what i really want to do is no how to automatically email a report, query or table. I also would like to be able to export the above three to excel as well. I have worked my way up a little bit but my hair is falling out with how hard this is to achieve. I have come up with the following so far:
Code:
Dim outputFileName As String
Dim oXL As Object
Dim oExcel As Object
Dim sFullPath As String
Dim sPath As String
[code]...
The above code works a bit, but it only allows me to export tables (dont know how to modify it). It also doesnt open the table in excel properly, it opens excel, but the table doesnt open. I have to go to the location and manually open it.
View 6 Replies
View Related
Jan 12, 2012
In my database, I need to have a button on a form which when pressed (1) pulls the email address from the displayed record on that form, (2) loads an Outlook instance, (3) in that Outlook instance, load a drafted email for editing and sending.
More detailed: My form, frmReferrals, contains the email address of a contact. I need to have a button, cmdEmail, which loads the email address of the displayed record in an Outlook instance. Ideally, I would like the loaded Outlook instance to pull some other information from the form. For example, I would like it to pull the name of the contact and display it.
Something like this:
"Dear " & [FirstName] & " " & [LastName] & ","
Leads to this:
"Dear John Smith,"
There would be a lot more text in the email with other information to input automatically. I would prefer to use as little coding as possible... but I suspect that all of this will have to be done with coding.
View 2 Replies
View Related
Aug 7, 2015
My database is stores information about students such as name, student number, programme, email, etc. I have a STUDENT form with this information visible.
I also have a another table and MARKS sub form that contains the details of courses completed by the student and results. I have placed the sub form in the STUDENT form and can see each student's details and a list of their courses.
I want to be able to send this information to the relevant student via email. The student should only receive his information and no one else's.
Can this be done? Do I need to create a report first? Should I be using WORD to produce the emails?
View 1 Replies
View Related
Apr 21, 2015
I need to create a word file (it needs to be word) based on template (not a very complicated template) max 1 to 1 and 1/2 pages long.
the word doc needs to be named from the recordset but for now assume 12345.doc and the next one will be 12346.doc etc (I have a unique number system - available from tables /query .
i can either make the word doc in code or use a template (template would be better) recordset could have 20-30 in it each time i run it - but to be run every week
second half is how to email this out. i had in mind a email system
email to . test@testhotmail.xyz
file attach = this folder where the docs are store and attach 12345
in a loop
so either
create word file - email word file in a loop each time or create all the word files and then send them individual
View 4 Replies
View Related
Jun 24, 2005
I created this database long time ago, but now my boss wants to import the contacts list from outlook into the database. Now, these lists will differ per user. Right now there are 6 users, who are using the database and they all will have different contacts lists. How can I import it in a manner, when they login the outlook will will search for their contacts only and let them make changes.
I want to create a form and this form will already be filled with the contact info from the outlook, and half of the form is for the user's comments so they can circulate the information through a report to different people.
I hope I was able to send my msg across. I am pretty bad at explaining stuff.
Thank you in adv.
View 1 Replies
View Related
Mar 30, 2007
if i receive an email consisting of the following:
Name: Antony
Phone: 887
Country: UK
can there be a way to transfer these details from outlook into an access table with 3 identical fields?
View 4 Replies
View Related
Apr 23, 2013
I currently have a database that creates an email pop up when running queries. I would like it to instead, create the emails and have then post in my Outlook draft box. How can I make this change?
View 1 Replies
View Related
Dec 11, 2006
Hi All,
Apologies if this question has already been asked. Im a bit of a newb when it comes to Access. I was wondering if its possible to create a input form/email in Access/Outlook in which I can send to a number of people via email that populate a Access database/xls when they reply?
Extra Info:
-Users may have a different version of office that I have.
-I have office 97, 2000 and 2003.
Hope that all makes sense.
Ollie
View 3 Replies
View Related
Jan 8, 2015
I have a database where I record grades for my students. I would like to create a macro so that every time I record a grade as an "F", the student will receive an email that will contain an attachment of their scores. A lot of the information I want to include in this email is in several different tables. So to make it easier, I have created a query that lists the following:
Students name (SName)
Student's email (SEmail)
ID# of the form I use to record their grades (ID)
ID# of the studen'ts work (WorkID)
Date of their work (CreatedDate)
Date I graded their work (AuditDate)
Grade="F" (Accuracy)
How can I create something that will automate emailing of this information--to the individual student with only their information? I am using Access 2010. If I can't automatically send the emails, I would like to create a button in my audit screen that will send a report containing that student's information to them.
View 1 Replies
View Related
Sep 22, 2005
Can anyone tell me if it is possible to link access to outlook so that access can send out reminders through outlook to people regarding different information??
View 1 Replies
View Related
Oct 4, 2005
Hello,
I am running a database in Access 2000. My code for creating an Outlook message from Access was running perfectly until my company switched us to Outlook 2003. Has anyone had a similar experience? Were you able to fix it?
Thanks much,
Pat
View 1 Replies
View Related
Jan 23, 2006
Hi
I wonder if someone could give me some advice.
I can create simple databases with Access but I've recently identified the need to create something a little more complex. My entire relational database revolves around a central table of contacts.
I have a list of contacts in MS Outlook (searchable by name, phone number, etc.), which should be the same. I want to avoid the risk of data redundancy so I was wondering if it is possible to link Outlook and Access databases in some way, so that, for example, if I was to add a contact in Outlook, it would update my database automatically and vice versa.
I'm sure this is far from simple but I'd love to hear any suggestions you may have.
Many thanks in advance
Gavin
View 1 Replies
View Related
Mar 19, 2006
Hi everyone,
I wanted to know if there's a way to implement a calendar in MS Access? In other words, I'd like to create a calendar that act the same way as the Outlook calendar? At first I tought about the calendar control 8.0, but we can't write anything in a square date of the calendar. So , I'm out of idea.
Thank you in advance for your suggestions!
View 3 Replies
View Related
