Problem Exporting To Outlook Contacts "street+nr" --> "street"
Jul 16, 2006
Hello,
I made an address database in access, with the intention to export it to Outlook contacts. But in Access I made a separate column with "street" and another one with the "number" of the house/apartment. If I try to import the addresses in Outlook, I can only drag one column to the "street" field in Outlook (where street and number are considered to be in that field together). Is there a fast solution for this?
I'm thinking of combining the street and nr columns in Access (if that's possible) into a new column, so I can delete the separate columns..
If you know how to do this or to fix this issue any other way, please let me know.
Thanks
View Replies
ADVERTISEMENT
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
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
Apr 23, 2014
I know how to create new table in Access by linking to Outlook contacts. The problem is, the default NOTES field in the Outlook contact does not show up in the linked Access table. Every Outlook Contact field shows up with the exception of that one field.
View 3 Replies
View Related
Oct 4, 2004
Two questions:
1.I have disabled all menus and assigned a custom form to load when the database is launched.
The form launches with the Main Access window in the background.
Is it possible to have this main window invisible; either minimised or absent?
2.I have created a linked outlook contacts table in my database. I have a feature in one of my forms which searches for contacts based on certain selections.
When a contact is found, it needs to be displayed. I will like to use the existing Outlook contact detail forms to pop up. I can make a custom form to display this info, but it seems a waste of time to code what outlook already has.
Can someone give any ideas? or, direct me to some reference material?
thanks!
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
Sep 20, 2006
hi,
i have a table name datatable with fields TO,CC,BCC,BODY, and Buttons "get address","send mail","clear","save","Attachments",.
on pressing get address i want a new form from where i can add recepients from outlook address book to TO and CC fileds.
on pressing Attachments i could be able to attach multiple files.
on pressing send mail it should send the mail.
on pressing save it should save in the datatable.
on pressing clear it could clear the form.
plz help
View 1 Replies
View Related
Sep 24, 2004
I am trying to create an Access file to manage another individual's contact database and journal entries in Outlook. Is there a unique field in Contacts that ties the record to the Journal entries? I've figured that we may need to re-create the individual's company name to make it unique, but how would I get that new name linked to the journal entries (without doing a manual cut-and-paste)?
Without doing so and importing the two tables into Access, it appears impossible to link the tables to establish relationships.
Can anyone please help?
Thanks so much!!!!!
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 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
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
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
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
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 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
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
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
Jun 19, 2013
I very new to Access. I am using the Contact Database template from MS and added a field of text. I am trying to get a query to search the field for partial text. I've typed the following parameter to narrow it down because I only need partial information:
Like "*" & [How are the contacts involved in Organization?] & "*"
I used the query builder off of a report that was already created. I just want to be able to get contacts on the report that match the parameters inputted into the box.
When I run the report it gives me the following error:"You either have an error in your expression or you have attempted to use an undeclared parameter. Check the expression for errors or enter the parameter '[How are the contacts involved in Organization?]' in the Query Parameters dialog."I hit OK and it pulls up the report without data filled in.
View 1 Replies
View Related
Sep 24, 2012
I have a contacts database and I am trying to set the relationship between the contacts table and the locality table. The contacts table has a LocalityID field that is a long integer and the Locality table has an autonumber as the PK. When I drag the LocalityID on one table to the other LocalityID I get the Can't create this relationship. When I look at the Edit Relationship dialog box the primary table is the Locality table not the Contacts table. I want set up a lookup on the contacts form that relates to locality.
View 4 Replies
View Related
