Search Corporate Email Contacts But Do Not Import
Apr 8, 2013
I work for a large company, whose contact directory in outlook is enourmous (thousands of employees). Outlook currently manages its contact directory very efficiently. its very easy to search and email individuals. In my access database I would like to be able to have that same functionality. To pull contacts from outlook via a search, without actually importing outlook contacts.
I am designing a database for asset tracking of Lab equipment. Lab equipment gets borrowed or relocated frequently and I would like to assign a name/phone/email quickly and without error, when I need to input a record of equipment movement.
View Replies
ADVERTISEMENT
Nov 15, 2004
I'm getting a Run-time error 2295: Unknown Message Recepients.
I've got a DB of about 2000 clients. In testing I did a test DB with 50 random
clients. Using any search criteria, it would grab those clients and open a new email
with their email addresses no problem.
However when I do this same thing with my complete DB of 2000 clients, I get this run
time error.
I'm pretty confused here, and anxious. It looks like the program is working, I just need it
to run with all my clients. This is the last thing I must conquer to be finished with this project.
View 3 Replies
View Related
Jun 2, 2006
I have a form that I am in the midst of creating.
On this Form there are several football club names (e.g. A1, B2, C3 etc.).
These buttons contain the Team List for the club. I have set a macro up to email the list to the relevant contacts for each Club.
But if some club changes the contact person, is there some way I can have the macro open in design mode on the form so that the end user (who may not be familiar with Access) can just change the email address. Or does this involve code, which I am not great with, but am trying to learn.
Any help is greatly appreciated.
View 1 Replies
View Related
Feb 3, 2015
I am using Access 2010 on a Windows 7-64bit machine. I am trying to begin an employee database using the faculty template. It would be exceptionally useful if the "Add from Outlook" command that is built into the "Faculty list" form would fill more than just the name, email address, and phone number fields. There are fields on the form for Department which match available info from the Outlook address book, but isn't imported.How can I tweak the command to fill the additional fields?
View 1 Replies
View Related
Sep 20, 2013
- I have emails with excel attachments coming in multiple times a day to outlook.
- I want to click a button in Access and automatically import the last excel attachment in my email in box based on the timestamp of when it came in (thus getting the last one).
View 2 Replies
View Related
Sep 11, 2013
I want to import email data into my access table. The email format is always same and the fields in the email match with the fileds in my table.
View 1 Replies
View Related
Jun 28, 2006
Hi there,
I am setting up a database at the moment. I do not have a lot of experience with Access but up to know everything was alright :).
I don't know if it is at all possible...but I would like to be able to find out who has a yes in a "yes or no" field and than that it shows me the email addresses of the people that have a yes there....does that make sense...I hope so.
Ok if that is possible, the second thing I want to be able to do is to email those persons that have a yes.
I have understood by now I will need codes and everything. Problem is I don't know anything about creating codes...so would be great if someone can explain that to me. And is it right I put those codes into a new module?
I hope this all makes sense and that someone will be able/willing to help me.
Thanks in advance!
View 2 Replies
View Related
Oct 14, 2004
***Updated*** Search/Email Results has been solved....Working out some bugs and trying to add a Print Address Labels option to the search. The post at Date Nov. 5, 11:4x is the new post with updated info. Thanks! ***Updated***
I have read a ton in the last hour or so on this subject and gained a little insite, but since I have no Access programing experience I am still pretty lost. However, I have programing experience in other areas, so if it requires some macros, I shouldn't have too much trouble. /crossfingers
I have put together a database for the business I work for that contains around 3,000 contacts.
I am trying to figure out a way to do a search that will search out specific contacts and email them a newsletter. Their email address is included in their contact information. So I assume I need a way to search for a specific criteria, grab their email address, and then email them with either an attached document, a prior written email, or have included the newsletter in the body of the code to add into the created email.
Any thoughts?
Thanks so much for your time,
Nick
View 14 Replies
View Related
Nov 25, 2013
How I could initiate a search from MS Access on an Outlook folder for an email addresss.
I would like to to work just as if you were using the outlook 'Try searching in All Mail Items'
View 11 Replies
View Related
Nov 30, 2004
Ok here is what was going on. I have an option group, I would select an option,
type in my search criteria into a text box, and click an event button. The program
would then search my database for that criteria and grab the emails of the individuals
meeting that criteria. A message box would then pop up, listed all the emails it had grabbed
I would click ok (my sendobject command is set to edit the email) and at this point instead of
opening the email to edit the program would crash.
After scratching my head for several days I moved on and have come back to this problem again
two weeks later, and within 15min I realized what was wrong. I guess it is good to walk away
and come back fresh sometimes.
What is happening is that the program does not account for entries in my database that do NOT
have an email.
Example, let us say we want to search a state...lets use the state of GA for example. If I have 5 entries
from GA with email addresses and one entry from GA without an email address, it will crash the program.
My only guess is that the way the program is setup is that it is grabing whatever data is in the email location.
It that location is blank, its grabing blank and crashing the program.
I need a way to discard the entries it searches that don't have email addresses or something...
Please help, this is the last item for this project.
Here is the current code:
Code:'Code by M. Walts'Important information! this code requires a reference to the Microsoft DAO object libraryOption Compare DatabaseOption ExplicitPrivate Sub cmdEmail_Click()'will hold the dynamic SQL queryDim strSQL As String'will hold the WHERE clause portion of our SQL queryDim strWHERE As String'will hold all the recipients of this messageDim strRecipients As String'the recordset we will use to get the emails of the records that match our criteriaDim rst As DAO.Recordset'if there is input in the search criteria, then we will run the query and send the e-mailIf txtSearch <> "" Then'if you have more buttons, just add mosr cases (the value of the radio button'= the Case number, so Value of the State radio button is 1, etc.)Select Case opgSearch.ValueCase 1strWHERE = "WHERE State = '" & txtSearch & "'"Case 2strWHERE = "WHERE PrayerSupport = '" & txtSearch & "'"Case 3strWHERE = "WHERE Denom = '" & txtSearch & "'"Case 4strWHERE = "WHERE PACTTrainer = '" & txtSearch & "'"Case 5strWHERE = "WHERE PACTPartner = '" & txtSearch & "'"Case 6strWHERE = "WHERE City = '" & txtSearch & "'"Case 7strWHERE = "WHERE Donor = '" & txtSearch & "'"Case 8strWHERE = "WHERE MailingList = '" & txtSearch & "'"Case 9strWHERE = "WHERE Conference = '" & txtSearch & "'" Case 10strWHERE = "WHERE YouthPastor = '" & txtSearch & "'"Case 11strWHERE = "WHERE PreviousCustomer = '" & txtSearch & "'"End SelectstrSQL = "SELECT EMail FROM tblUser " & strWHERE'run the query and get the results into the recordsetSet rst = CurrentDb.OpenRecordset(strSQL)'Loop through the recordset and add all the EMailsDo While Not rst.EOFstrRecipients = strRecipients & ";" & rst!EMailrst.MoveNextLoop'remove the first ; from the strRecipientsstrRecipients = Right(strRecipients, Len(strRecipients) - 1)MsgBox strRecipientsDoCmd.SendObject , , , , , strRecipients, "Email Subject", "Email Body", Truerst.CloseSet rst = NothingEnd IfEnd Sub'stops a ' entered in the field from breaking the queryPrivate Function SQLSafe(safeMe As String) As StringSQLSafe = Replace(safeMe, "'", "''")End Function
View 2 Replies
View Related
Dec 3, 2013
I'm trying to see if can search outlook exchange from access vba to get email address (using windows user name) .
View 1 Replies
View Related
Nov 8, 2004
Ok, I've run into two serious problems in testing, and another question that I'm hoping you guys can
help me solve. Below my questions is the code used for making the search query/email program.
Problem #1: In testing, this search program only is working for me for new data. Any data that I had
in the database prior to implimenting the program will not move past the search stage. In other words, I
will do a search, it will find the emails and bring them up in a box, I hit "OK" and it gets hung up and won't move on
to opening up a new Email with the addresses implemented. However if I enter new data in the database, say with a weird
name so its only bringing up the new entry and no old entry, it works fine and opens up the new email.
Problem #2: Items I would like to search like check boxes. Say I have a check box "Donor", this is listed in the database
as a 1 or 0. I can't have my boss searching 1 or 0. Is there a way to change this to, say, being recorded in the DB
as a Yes or No. That way he would check to search "Donor" and type Yes in the search box and this would search the DB
"Donor" column for "Yes" and bring up the results.
New Question: My boss and I reviewed the form as it is so far yesterday. He was asking if I could add a Print Labels option
in there. I'm wondering instead of adding another seperate search box and all that mess for a labels search print, can I rather
add two check boxes, one labeled "Print Labels" and the other labeled "Email". What this would do is depending on the check box
you selected it would either run the search and email like we have it, or clicking the other check box would run the search and print
labels.
Quote:
'Author: Michael Walts, but use it as you like'Important information! this code requires a reference to the Microsoft DAO object library
Option Compare Database
Option Explicit
Private Sub cmdEmail_Click()
'will hold the dynamic SQL query
Dim strSQL As String
'will hold the WHERE clause portion of our SQL query
Dim strWHERE As String
'will hold all the recipients of this message
Dim strRecipients As String
'the recordset we will use to get the emails of the records that match our criteria
Dim rst As DAO.Recordset
'if there is input in the search criteria, then we will run the query and send the e-mail
If txtSearch <> "" Then
'if you have more buttons, just add mosr cases (the value of the radio button
'= the Case number, so Value of the State radio button is 1, etc.)
Select Case opgSearch.Value
Case 1
strWHERE = "WHERE State = '" & txtSearch & "'"
Case 2
strWHERE = "WHERE City = '" & txtSearch & "'"
End Select
strSQL = "SELECT EMail FROM tblUser " & strWHERE
'run the query and get the results into the recordset
Set rst = CurrentDb.OpenRecordset(strSQL)
'Loop through the recordset and add all the EMails
Do While Not rst.EOF
strRecipients = strRecipients & ";" & rst!EMail
rst.MoveNext
Loop
'remove the first ; from the strRecipients
strRecipients = Right(strRecipients, Len(strRecipients) - 1)
MsgBox strRecipients
DoCmd.SendObject , , , , , strRecipients, "News Letter", txtBody, False
rst.CloseSet rst = Nothing
End If
End Sub
'stops a ' entered in the field from breaking the query
Private Function SQLSafe(safeMe As String) As String
SQLSafe = Replace(safeMe, "'", "''")
End Function
View 1 Replies
View Related
Jan 13, 2007
Hi, I’m new to access and I have read through a couple of books but still struggling.
If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or
I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.
I’m thinking of an invoice made up of info from a contact table
My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice
Hope this makes some sort of sense, can any one point me to some key areas that I can read up on
thanks
View 2 Replies
View Related
Aug 10, 2006
Hey Everybody,
I have 2 tables, one called [Addresses] and the other called [2006_Contacts]. The table [Addresses] has a number of various fields relating to contact data of people. The [2006_Contact] table has 2 fields [Last Name] and [First Name]. I want to run a query that pulls the contact data from the main [Addresses] table, but only if the contact name ([First Name] and [Last Name]) are present in the table [2006_Contacts].
Does anyone have any suggestions?
Thanks,
Chris C.
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
Sep 14, 2005
and it works mainly except for two problems:
(1) I renamed all the forms on the Database main window. But when I open the forms, on the top blue bar, it still reads the old names. How do I change that to new names?
(2) I've changed the "Calls" table and forms to "Actions." I've renamed the "Calls" button on the main "Contacts" form which is now "Projects." The old key field "ContactID" is now "ProjectID."
When I click on the "Calls" button to go to the "Calls" form/subforms, box says "cannot find field "ContactID" referred to in your expression.
How do I fix it so that it recognises the new key "ProjectID"? They are linked correctly on relationship--or at least they're linked exactly the way it was linked in the template.
HELP!
THANKS!!!
--Joy
View 2 Replies
View Related
May 8, 2006
Hi there, I am pretty much a newbie on Access. (yay). Now I am doing a simple contacts database and need to assign whether specific contacts wand information being sent to them. Now I have all the other fields required. But the check boxes that I have put on the form are not changing according to the contact. (as in if the check box is ticked, it is ticked for all of them):( :confused:
How do I go about assiging it specifically to that contact? - If I am making sense. Any hints/tips would be greatly appreciated:)
View 1 Replies
View Related
Dec 19, 2006
my custom have a big table in the outlook, in the contacts.
in the outlook table that possible to insert also the birthday.
my custom want to send mail day-before the birthday to wish.
I want to do it with access, to link the table to the contcts and send mail if the birthday is tomorrow.
but when I try to connect to the contacts in the outlook, i get the fileds:
first name
last name
email
....
but no the birthday and the anniversary
(the table design attach)
how can I use this filed in access?
View 1 Replies
View Related
May 9, 2005
Hi.
Im a beginner-intermediate access user (I guess) and I am working on a stakeholder management database, which essentially enables me to separate organisations, individuals, the affiliation between the two, and addresses of either individual or organisation. (pic of relationships included).
Originally, I stored address values on each respective table (ie. org address was on the org table, individual address on the individual table). However then it became apparent that one organisation (in my line of business) can have many address sites, therefore the need to nominate multiple addresses.
So I figured that the best method would be to have an address repository, and orgs or individuals are assigned to that address via a MultiAddress table. The preferred postal address would be nominated by an address preferred field in another junction table.
Seems to work ok through the form (see form pic attached), but Im concerned that when I try to run queries/reports that I'll get duplications or other anomalies.
Can anyone provide me with some tips or advice???
Cheers
View 2 Replies
View Related
Aug 20, 2005
Hello All,
At work we have a large and messy Contacts list so I decided to set one up using a database.
At present I have 3 tables:-
Companies (custID,companyname,address,etc)
People (nameID,firstname,middlename,lastname,custID)
Phones (phoneID,phonetype,areacode,number,?????)
My problem is this, Some of the phone nos belong to the individuals
and some belong to the company. If a person is replaced at a company I need to reasign the company phone nos to the new person whilst retaining the individuals and their personal phone nos. If a company is deleted I need to delete only the company phone nos. and if a person moves within the company I want the company nos to reasign to the new replacement but keep the personal nos of the individual. Now I see its going to be more complex than I thought.
Can anyone help me with the table layout and links. (nb this is only a simple database relating a person to a company without using departments etc.)
Its main use is to provide phone nos names and addresses quickly.
Many Thanks
Peter
View 4 Replies
View Related
Feb 8, 2005
I am bulding a contacts DB for work and am a bit of a newbie with Access.
I have a table for Individuals and a table for Organisations. Both have address fields.
On the individual's form there is a drop down for Organisation, which is linked to the organisations table (fk). The form has a sub-form which displays work address. I want the work address field to update to the Address field in the Organisations table when an organisation is selected on the drop down.
I am using Acess 2003.
Could somebody point me in the right direction please?
View 2 Replies
View Related
Jan 2, 2014
I'm creating a database full of contacts. I have a contacts table with detailed info on each contact and I also have a company table with details on each company - all companies attached to a contact are in the company table plus a few others. I'd like to be able to pull up a company profile and see all the contacts we have associated with that company displayed in a list.
View 1 Replies
View Related
Jun 30, 2015
I'm trying to set up my own form for my customer contacts.
I have TABLE A that lists general customer information.
I have TABLE B that lists customer branches (each customer has multiple branches).
I have a combo list set up so that if I select a customer name, the rest of the form populates with the customer general information.
Is there any way I can filter out a list depending on what customer is selected?
I only want to see the branches of the customer I've selected on the COMBO box.
View 2 Replies
View Related
Apr 29, 2014
Ok, I have 3 tables. One lists a contact in conjunction with the branch of the company and the trips that contact takes. The second lists a contact in conjunction with the branch of the company and which team they work with (may work with many). The third should list their email address and their phone number. Is it possible to pull the contact name and branch of company from tables 1 and 2 into 3 automatically, such that all I have to input into table 3 is additional contact information? If that is possible, is it also possible to only pull each contact/branch of company pairing once (I don't want four entries for Joe Shmoe/Sales, even if he's taken 4 trips)?
Table 1
Branch of Company
Trip Dates
Trip Location
Contact
Sales
4/1/14-4/12/14
Chicago
Joe Shmoe
HR
6/2/13-6/4/13
New York
Jane Doe
Table 2
Branch of Company
Company Team
Contact
Sales
Blue Devils
John Deere
Sales
Jets
John Deere
Sales
Jets
Joe Shmoe
HR
Sharks
Jane Doe
Table 3Contact
Branch of Company
Email
Phone
Jane Doe
HR
jane.doe@company.com
800-555-1234
Joe Shmoe
Sales
joe.shmoe@company.com
800-555-1235
John Deere
Sales
john.deere@company.com
800-555-1236
View 4 Replies
View Related
May 21, 2005
I'm using Access 97 and have merged the 'Event Managment' & 'Contact' templates. I thought that I would need to make 'Contacts' and 'Attendees' as the same table.
My knowledge is limited and attempts to change to 'AttendeeID' means I lose the ability to log 'Calls' to people.
Is there a simple way of combining the functionality of both databases given my limited ability in using access?
Any help would be greatly appreciated.
Many thanks
Adrian
View 2 Replies
View Related
May 15, 2013
I need setting up a history table for contacts and the companies that they are associated with. I am sure this will be obvious to some of you database veterans but I am fairly new to Access and I can't seem to figure out the best way to accomplish what I am trying to do.
Here is what I need to do:
When a contact's employment status changes, I need to change the contact's current company association but somehow maintain his or her association with the previous company so that s/he can still be associated with past projects.
So, in my contacts table (TBLContacts), I have a foreign key field "CompanyFK" that links to my companies table (TBLCompaniesPK). There is a one to many relationship between TBLCompanies and TBLContacts.
I want the CompanyFK field to be the current company but somehow link the person with past companies too so that the project directories and subforms will continue to show the contact's association with the parent company.
Maybe I don't need a history table but something else?
I have a similar problem with companies that change name, too. How to deal with takeovers, name changes, mergers, etc.
View 5 Replies
View Related
