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

Reminders

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

Reminders

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

Pop Up Reminders

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

Pop Up Reminders

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

Automatic Pop Up Reminders

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

Using Reminders In Access

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

Running Reminders Through Access

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

Can Set Alarms / Reminders In Access?

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

Forms :: Form Reminders For Specific User Only?

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

Outlook

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

Outlook

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

Outlook

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

Outlook Fields

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

Any Way To Set Outlook Appointments From A Db?

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

Outlook Running?

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

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

Exporting To Outlook

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

General :: Use Outlook In VBA?

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

Outlook - Multitasking Macro?

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

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

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







Copyrights 2005-15 www.BigResource.com, All rights reserved