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 Replies

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

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

Link Table To Outlook (2007)

Dec 14, 2007

Hi,

Ok this is a weird one. I have used the automated link table in Access to connect to the contacts folder in Outlook. Both of these being 2007v

Originally this seemed to all work fine and i could see all the data. Now however i am having a problem where i can see all of the data apart from the email addresses. These are input in outlook and they are the correct field names - in fact they have shown up but when i though i had cracked it and saved and closed the db, when i reopened they had disappeared again.

I can work out whether this is a bug or a security setting. Any ideas?

Thanks

View 1 Replies View Related

Link Table To Outlook Contacts Problem!

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

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

How To Export Access Table As Outlook Contact Group Without First Using Excel

Aug 6, 2012

I have an Access 2007 SQL database with 20 users. The DB has a list of about 3,000 email addresses that I want to export to Outlook for mass mailing. I've already got the services of an SMTP mail service that allows 1000 mails at a pop to be sent, and I've already written in the logic to separate the list into groups of 1k.

The problem I'm having is that I'm currently exporting from Access 2007 to Excel 2003 format (for some unknown reason Outlook 2007 does not directly interface with Access 2007), and then I have to manually go through the import steps within Outlook to bring the data from each 1k name group spreadsheet into a contact group for mailing.

It all works fine as it is, but it's clunky as hell. I want to automate that process, but I'm not very familiar with Outlook. I'm not even sure what the file format is for a group. Surely it must have its own format, like group1.xxx, or something. My ultimate objective is to export straight from access to the .xxx (whatever it is) format, direct it straight to the appropriate folder within Outlook and in the process eliminate the need for the more tedious steps required to import each Excel file within Outlook that I'm currently using.

View 8 Replies View Related

Link Table From .mdf (sql Srv) File Into Access Db

Mar 8, 2006

i have a pc which doesn't have sql server installed. is it possible to link tables from .mdf file sitting on the pc into access database?

View 1 Replies View Related

Link Image Files To Access Table

May 1, 2013

I'm using Access 2013. I have a directory on my hard drive that contains hundreds of image files. The name of the image file matches a field in the Access table, which are unique. I would like to match those files to the unique number in the table and create a link in a field. How would I go about this.

View 12 Replies View Related

Access 2003 - Link To Table Not Getting Saved

Jan 28, 2013

I am linking the Access tables with another Access Database. But after exiting from Ms Access application links are not getting saved. the version of both the DB are Access 2003.

View 4 Replies View Related

Link Access Form To A Table Stoed On An Intranet Site

May 24, 2006

Dear all,

Does anyone know if ti is possible to link an access table to one stored on an intranet site? This is used for logging help desk calls and various locations need to look at it at the same time.

I have tried it and seems to work but I get a "Not a valid file name" message

thanks for looking

View 1 Replies View Related

Rename Access File With Excel Pivot Table Link

Jan 8, 2007

Hi,
I would like to rename my access file. My problem: I have many pivot in excel link to this database so if i rename it all the links will be down...How can i resolve this?:confused: (of course rebuild all pivots could be a solution but I have around 50 pivots behind my database)
Thanks for your help!

View 1 Replies View Related

MS Word Link MS Access Table Data - Avoiding Duplicates

Dec 7, 2007

Hi All,

I have an MS Access table that currently links into word as a mail merge. Great!

Sample data as follows:

Tutor Student
Mr A Donald Duck
Mr A Mickey Mouse
Mr A Minnie Mouse
Mrs B Joe Bloggs

I want to produce a mail document that allows me to address each tutor separately, along with the respective student names in a grid.

Now I've setup the document, but when I view each document it produces the list of all students for each tutor.

e.g.

Dear Mr A

Your students are:

Donald Duck
Mickey Mouse
Minnie Mouse

-------------------

Dear Mrs B

Your Students are:

Joe Bloggs

Is this at all possible?

Thanks:)

View 1 Replies View Related

General :: Access 2007 Link Table Manager Don't Work

Dec 13, 2012

I have an Access 2007 application where don't work the link table manager.

I also try to complete reinstall the Office 2007 and also I register the Accwiz.dll in the office folder (regsvr32.exe Accwiz.dll) but the module still does not work.

View 2 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 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

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 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

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