Linking Access With Outlook

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 Replies

Linking Outlook And Access...but Adding Autonumbers

Feb 19, 2007

Hello Everyone

I have a question which hopefully someone can help me with.

I have a database that links into an Outlook email account. I get the information across via File => Get External Data => Link Tables.

However the issue I have is assigning some kind of autonumber to this table. I am not bothered what the number is, just so that I can differentiate between the records.

Is there an easy way of doing this?

Thanks in adavance

View 1 Replies View Related

Linking Access Table To Outlook Calendar

Oct 26, 2004

Hello Guys,

I'm totaly new to access and outlook applications etc..
What I'm trying to do is link an access table to my calendar in outlook. I can do it but there is one problem it is not importing all the fields. But when I do an export from outlook to access database file all the fields are there.

Can someone help me with this issue?

P.S. I'm using outlook 2003 and connecting to exchange 2002.

Thank you for all the help I can get

View 2 Replies View Related

Linking Outlook Calendar To MS Access - Appointment / Meeting Date And Time

May 30, 2013

I have linked a Shared Calendar from MS Outlook in MS Access. The fields that I need which are Appointment/Meeting Date and Time are not there, only creation date/time. Is there anyway for me to get the Appointment/Meeting Date and Time from Outlook into the table?

Windows 7
Office 2010

View 1 Replies View Related

Outlook 2010 Contacts Linking - Notes Field

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

Access/Outlook?

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

Outlook And Access Link!!

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

Outlook 2003 And Access

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

Outlook Calendar And MS Access

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

Linked Outlook With Access

Mar 27, 2006

Hi, forum.... I have a linked table that was created to view info in outlook. The problem is i need to be able to view or hyperlink to the attachment in access as well, for some reason in the attachment column it give me a yes or no field value only.... any ideas?

View 1 Replies View Related

Import From Access To Outlook

Jun 26, 2006

Hi,
I want to import a contact database to outlook but for that I have to design new fields in the Outlook form. The design is no problem, and I can even enter information and save it, but when I want to import data from access, it does not show the new fields!?

What could I do? Any idea?
Thanx!
john

View 1 Replies View Related

Access And Outlook/Exchange

Jun 6, 2007

I have searched the forums and did not see the question I am about to ask.

I have created a link table in Access to the exchange server at work. When I try to get someone to view the table I created they can not view it. When I look at the Link Table Manager it shows the link is pointing to my personal temp directory instead of the main folder in exchange. How do you link the table to a folder that all can see?

Thanks

View 2 Replies View Related

Help, Incorporating Outlook Into Access???

Jul 10, 2007

How can I incorporate outlook and the use of contacts in outlook into my access database?

View 2 Replies View Related

Access And Outlook Calendars

Aug 27, 2007

Hi Guys,

I'm really not sure about this one! I seem to remember reading about it but I can't find anything on it in the books.

Can you create a diary/task reminder in Outlook from an access database. I'm creating a service and maintenance database and the customer wants to be able to create reminders in his outlook by just pressing a button - is it possible?

Thanks,

Dx:confused:

View 2 Replies View Related

Using Outlook / Email With Access

Jan 22, 2008

I have a Access training database which tracks employees trainings as well as their annual recertification dates on particular trainings. Is there a way to have an email sent to the employees automatically when their recertification date is 1 month away?

View 3 Replies View Related

Outlook Opens Access?

Sep 25, 2005

I have a pesudo forum running on a server which sends emails automatically to a group to indicate that there is a new posting - much like any forum...

I would like to include a link in the email (automatically) that will open the Access Forum and point directly to the relevant post...

I searched the forum but was surprised to find that this question hasn't been raised before... so I'm worried? :p

I know I will get a hundred links from the Mighty Moderators now saying I didn't look properly - as my old mother used to say :rolleyes:

Dave Eyley

View 2 Replies View Related

Ms Access And Ms Outlook (is There A Way To Link Them?)

Jan 30, 2006

Hello,

Is there a way in Access to create a database that stores (a list of) Ms Outlook emails? And then, is there a way I could drag and drop an email from Outlook into the access database?

Thanks...

Willchum.

View 3 Replies View Related

Exporting Outlook To Access

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

PDFs, Access, And Outlook. Oh My

Feb 13, 2006

I am trying to get an access report to save a pdf file, then with a control button create and e-mail and attach the email and send it. Has anyone coded anything like this?

View 1 Replies View Related

Outlook Email From MS Access

Aug 7, 2006

Hi
I have written a code that composes a new mail from MS Access. It does what i need. It also gives a question before displaying the mail body :
"A program is trying to access e-mail addresses yo have stored in outlook. Do yo want to allow this ?"

If I give yes, it proceeds with composition. If I give No, it gives an error "Application-defined or object defined error". Is there any way I can avoid this error.

Thanks

View 2 Replies View Related

Synchronization Between MS Outlook And MS Access?

May 22, 2012

MS Outlook contacts to MS Access database table to get in,MS Outlook contacts to an Access database?

View 12 Replies View Related

Producing Outlook Email Thru Access

Apr 29, 2005

I have code to open a new email and populate the BCC field. My problem is the company usually uses a template for all emails they send, from access how to I het outlook to use the the usually template?

Thanks

Paul

View 4 Replies View Related

Accessing An Outlook Template From Access

Nov 15, 2005

Hi there,

I am not the best in Access, I will admit. But need a function to open up a MS Outlook template (.oft file) within Access which is hosted on an internal server. Anyone help with quick steps on how to do this, It would be greatly apprciated.

View 4 Replies View Related

Sending Mail In Outlook From Access

Jan 19, 2006

I've got information stored per row with the name of the person which data-entried the information.
If a user wants feedback from that user on that specific row i would like to make it able to send a mail to the data-entrier. The data-entrier name should be clicked in the row and that specific row should be attached in the mail.

I can store e-mail addresses of my data-entriers in the database, how do i achieve to send the mail address and specific row to outlook when a user clicks it?

View 2 Replies View Related

Access For Mass Mailing Causes Outlook ???

Feb 3, 2007

I have a database for clients and have set up a form and code to run a query for different types of clients and to send emails to the group.

Everything works fine until I try to send and then I get a Microsoft Outlook pop-up which states:

"A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No."

This message stays for 5 seconds and then I can click on "YES" and it will send the email, and start all over for the next recipient.

I am assuming this is an Outlook Spam Blocker, but is there any way to stop it?

Thanks

View 1 Replies View Related

Link One Table From MS Access To Outlook

Dec 11, 2005

Hi,

I have a question.

Can MS Access table link to Outlook?

Suppose there are Tom and Sue persons:

Sue manage the acc.mdb database file, The database has one table which is called "input", Sue made the form, the form is come from "input" table info. and also Sue made one button to send the specific record to the Tom via outlook, once Sue send out, the mail has created a link, which link can open the document (NOT attached file). Once Tom receive the mail from Sue, Tom will click the link to open the document, and also fill out one signature inside the document, after filled it out, then the signature will automatically populate in the specific field of the "input" table in the acc.mdb database file.

Can MS Access and Outlook do above situation?

Please let me know, thanks a lot.

View 2 Replies View Related