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 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??
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?
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?
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)
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.
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.
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.
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.
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
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!
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.
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.
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?
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.
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.
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?
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!?
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?
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?
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?
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.