Outlook Reminders
Mar 1, 2007
Let me preface this thread by stating I'm an Access noob. However, I am fully capable of using the "search forum" section. Unfortunately, many of the answers given to somewhat similar queries are out of my range of understanding.
Here's what I am looking to do:
I work for a R & D company. My lab receives media and reagents of all sorts with various expiration dates.
We have an Access Database setup for what is in storage and from who... but it's really quite basic.
What I have been asked to look into is:
Is it possible to have Access automatically send an Outlook Reminder or Email based on the expiration date field within the database?
For example:
4 days to expiry of a Tryptic Soy Agar Plate, Outlook sends a reminder to the relevant people with a message that says something like:
Notice
You have <number of days until expiry> days until <item description> Lot # <lot number> expires.
----------
of course, i'm not even sure how to setup the email so it pulls the relevant information. I would be fine with it just sending out an email telling which item expires a set amount of days before.
um..
help please
View Replies
ADVERTISEMENT
Mar 9, 2006
real long shot here.....
Is there any way a record produce a pop up reminder (like tasks do in outlook) ?
I am considering running a database as a kind of WIP log and report but I am trying to avoid having to run two systems (Access to report , A task list in Outlook to remind)
Thanks
View 1 Replies
View Related
Jun 28, 2007
i have searched on this forum but so far am not finding the answer.
i have a database and i would like to have a reminder to events .
i have a form in which we have to indicate the place a person goes to.
i need to set a reminder if the person does not the minimum visits in a month.
we need at least three visits or outings in a month per person. i would the reminder to pop up 10 days before the end of each month.
sorry, i am still learning how to do codes. please help me with codes if you can.
i thank all for your help , i have learnt a lot from this forum that i did not learn in class.
View 2 Replies
View Related
Jun 16, 2005
Hiya guys,
I have just been asked to add a reminder function into a database, I have searced the forum, but not sure what I`m looking for.
When we deal with customers, some times we have to contact them again at a later date.
Is there anyway that we can get a reminder to popup, or send a reminder to a specific email address when a certain date criteria is met ?
obviously the database need to be open ( which is not a problem, as it`ll be used on a daily basis anyway )
Would I need to use querys, macro, VB etc to do this, or is there an in built function in access that I dont know about that could do this automatically.
Thanks in advance for any help.
Max
View 4 Replies
View Related
Jun 30, 2005
How can I go about creating pop up reminders for expired dates in (MS Acess 2003) forms for each record.
For example: Date Renewal = 31/01/2005
I need a pop up reminder popping up a month before the date renewal.
Thanks in advance! :)
View 11 Replies
View Related
Jan 21, 2005
Hi
I'm fairly new to Access and databases in general but I have built a great database which I am really pleased with, but I want to be able to have a pop-up reminder which is activated when a date in one of the form fields is reached.
First of all is this technically possible?
If it is could somebody give me an indication of how to go about doing it because I have no idea!
If it is not possible, is there any other way around it?
Thanks in advance for your assistance and the simpler you can keep any advice the better!!
Many thanks
Steve
View 2 Replies
View Related
Sep 10, 2015
I have a database where I have a number of contacts/clients/customers, I want to be able to put a next contact date in a field on a form and for either 1. get a reminder in the access welcome screen when the date is approaching along with the name of contact/client/customer or export that date along with info to an outlook reminder.
View 1 Replies
View Related
Aug 23, 2007
Is there anyway to use Access to run reminders?
I am trying to figure out the easiest way to have a reminder pop-up to run a letter for specific reps that would happen every 3 months.
Thanks for any help on this.
View 1 Replies
View Related
Jul 9, 2014
I am fairly new to Access, but understand it well enough to use it on a daily basis. I just need to know if it's possible to set a reminder in access and how to do it if it is possible.
View 2 Replies
View Related
Feb 25, 2014
In my database, I have a form of reminder.
Query collect all the information about the unfinished business at the base and at the start-up of the base shows form reminders.
The base is splitet into front and back end, and are located on the server. Each user is assigned rights what can be done in the database.
The problem where I am "stuck" is to make the form reminder that can be seen only by those users whose jobs are not completed and not all users of the database. Each user uses his computer with your username and password. I tried to connect to form reminder with this information, but I failed.
View 5 Replies
View Related
Dec 16, 2005
Can we design our own form in the MS Access?
And then connect to Outlook?
Because I go to outlook, it doesn't have connection option to MS Access,
whereas MS Access has it, but the we cannot custom the field or design.
Thanks.
View 1 Replies
View Related
Dec 16, 2005
Can we design our own form in the MS Access?
And then connect to Outlook?
Because I go to outlook, it doesn't have connection option to MS Access, whereas MS Access has it, but the we cannot customize the field or design.
View 2 Replies
View Related
Jan 5, 2006
I have a database that keeps track of client information and future apointments. I would love to hav this data merge with outlook to go directly into my calendar. Is this possible and how do I do it? :cool:
View 1 Replies
View Related
Jul 29, 2005
Hello,
I am trying to link to the fields in the Tasks section of MS Outlook. I am completing the following actions:
Under tables, right click, Link Tables
Files of Type: Exchange
Under my mail box selecting Tasks
Click Finish
The link table icon is displayed and a Tasks table is created. This contains all the data from the Tasks that I have in MS Outlook.
The problem is that it does not display all the fields. If I open MS Outlook and go to tasks --> Customise Current View --> Fields, there are a number of fields that can be added that are "Standard Fields." I have looked on the Microsoft site and it states that you cannot import custom fields. These however are not custom fields. They are standard fields that are not displayed.
Please Help!
Iain :cool:
View 4 Replies
View Related
Nov 9, 2006
I was wondering if there is a comprehensive way to set Outlook appointments from a db?
If not, that's what I figured. It's not like Outlook and Access are bundled together into some sort of suite of software where it would be handy for a set of tools that allow you to do such things...
View 2 Replies
View Related
Jan 27, 2008
Hi,
I'm sending an e-mail each time a spesific report is made. If the user has'nt opened Outlook, it is placed in Outlook's Outbox, and is sent first when the user opens Outlook. Can I somehow start Outlook using VBA so the email gets sent when the report is run?
Also, The user is prompted with a warning message that an application tries to send an email. The user has to allow this for the mail to be sent. I know this is a security matter so no applicatopn can send emails without the user knowing. Is there someway to do this without the warning?
I'm using WXP and A2K3
Thanks in advance.
View 5 Replies
View Related
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
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
Feb 3, 2013
I am using outlook to send/receive mail. That is OK but I want to know that who send me mail(from: name of sender mail).
View 6 Replies
View Related
Jul 28, 2005
Hey there, folks,
Got one I need some help on. Perhaps one of you has tried something like this before...
I need to create a tool that will allow me to do the following:
1. Search an Outlook email box for all emails that have a keyword in the subject line that I have chosen from a drop list
2. Open all qualifying emails
3. Print all of them, including all attachments associated with them
4. Close the emails, and move them all to a folder
I've got the email box linked to Access (we've got 2003 running here), and I have no problem accessing the emails and even deleting them, etc. I can see if they have an attachment, but am unable to discern where it is or how to get to it to open it. I also cannot get the emails to show as "read" when I open them using the db. There is a col for "contents unread," but it is a number variable (I cannot change this since it's a linked table), and all rows are blank anyway.
It is important that I am able to print them including the attachments and move them out when done.
Whaddya think?? I'm open to any and all suggestions!
Thanks in advance,
Ceejay
View 2 Replies
View Related
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
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
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
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
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
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