General :: Access Diary Entries To MS Outlook

Jul 26, 2012

I'm running the following servers:

1. A Windows Server 2008 with MSEXCHANGE
2. A Windows Server 2008 with Terminal Server - my MSAccess database FE & BE is installed on this server.
3. Both servers are on the same LAN network.
4. The APPOINTMENT BOOK is in the MSAccess database and i have add the the idividual MAILBOXES in my tblEmployees.
5. I want the employees to make their appointments in the APPOINTMENT BOOK (4 above) and then the appointment must also be inserted/displayed in the employees MSOutlook calendar.
6. This works fine when the employees MSOutlook is open on the Terminal Server (2 above).

this will in effect mean that we need to open all users (emplyees) MSOutlook on the Terminal Server to insert the appointments from the MSAccess database into the MSOutlook calendar.I should think that there must be a way to insert the appointments from the MSAccess database into MSOutlook without opening all the the users MSOutlook on Terminal Server?

View Replies


ADVERTISEMENT

General :: Using Access To Manage A Folder In Outlook?

Mar 11, 2014

My manager wants to be able to implement a kind of punch card system for managing staff time. I'm thinking we could make a database that links to a folder in Outlook. Staff will be able to send an email to the inbox saying that they are, for example, going on a break at 10:50, and then another at 11:05 saying they have returned and are back to work.

This would probably add up to around 500 emails per day with the number of staff we have, so I don't want to have to keep all the emails to be able to add up break times etc.

I'll be extracting the timestamps, name, break description etc from the email and storing them in another table. What I would like to know is whether Access would then be able to delete the email from the inbox (or modify it in some way to reflect it has been accounted for), or whether this would have to be a manual task?

View 2 Replies View Related

General :: Rich Text In Outlook Email From Access Form

Sep 4, 2013

I am close to getting code to send an email from access with the body of the email populated with a Rich Text textbox from my access form. The problem I am having is that the body of the email is converted to plain text in Outlook which is creating problems for me. How to identify what I can do to convert to rich text or HTML in Outlook? I also want to attach a table that is populated by a query in my application, but i haven't got that far yet.

View 5 Replies View Related

General :: Using Access Database Of Suppliers Email Addresses And Use Them On Outlook?

Oct 24, 2012

I need to let all our suppliers know we have moved and wanted to do this by email. how I use Access database of suppliers email addresses and use them on Outlook.

View 1 Replies View Related

General :: Macro To Email A Form Once Condition Met - Open Outlook From Access

Apr 10, 2013

I have a macro set to email a form to a person once a condition is met. This works fine but I've discovered that Outlook (2010) has to be open BEFORE this macro is invoked.

I wanted to add a step to the macro before the one that makes it email that basically says to open Outlook.

I have tried the RunApplication macro, but I apparently am not getting the path right. I don't understand what the problem is.

I accidentally dragged Outlook to my desktop and therefore created a shortcut from my Start Menu, but now when I go to Microsoft Office in my Start Menu, Microsoft Outlook isn't one of the options. I can't find the path to where it may reside now.

I am using the path to the shortcut on my desktop.

C:UsersJust MeDesktopMicrosoft Outlook 2010

What else am I supposed to do?

View 8 Replies View Related

General :: Create Database In Access That Links To Contacts In Outlook Pst File

Nov 21, 2013

I have limited programming skills but a basic understanding of databases.I want to create a database in Access that links to contacts in an Outlook pst file, and in the Access database I want to create a series of date dependant tasks or processes that I can apply to the relevant contact.The object being to to save that collection of tasks to apply to different contacts within Access.

View 2 Replies View Related

General :: Send Outlook Email Based On List Of Emails In Access Query?

Sep 15, 2014

I've setup a selection form that returns a specific list of email addresses in a query.

What I can't work out is how to press a button and have the email addresses populate the To: field in a blank Outlook email - I don't need any bells or whistles.

View 8 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

Calendar/ Diary

Nov 1, 2006

Not sure if this is the right place

But do any of the calendar's available open a day to a time slot type expanded daily record.

i've seen one that lets you put notes on a whole day.

Hope you get what I mean

View 4 Replies View Related

Diary Type Form

Nov 8, 2007

Hi,

Within the past 3 weeks I spotted a post that was based around a diary type form, It is distinctive in the way that the guy had created an image using Photoshop or something similar and used it as a backdrop to the form.

It looked pretty neat.

Problem is I cant find it again and I think its just the type of thing I am currently looking for.

Does anyone recall it?

Garry

View 1 Replies View Related

Multi User Diary

Mar 22, 2005

i am looking for an outlook style planner in Ms Access for a booking sytem i am trying to put together, can anyone point me in the right direction of how best to tackle this please.

I have scoured the net for samples, and have come back to the most helpful place on the net for more assistance on where to go with this...

What i am looking to do is to set up something like this..

Click here to see example picture

how hard would this be to do?

Cheers

Andy

View 3 Replies View Related

Modules & VBA :: Filter Diary Data Using Two Dates?

Jun 7, 2013

I have a sub form dragged into a main form that shows all existing diary entries. I have already got code for various different filters but I am struggling to wrap my head around this one. Just want the user to input two dates and then the sub form to show all the diary entries between those 2 dates. Or maybe a drop down box listing various lengths of time from today's date and showing entries within that time scale. Whatever is easiest tbh. Would I have to use date diff for this?

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

Forms :: Diary Filter Not Returning Correctly Filtered Records

Sep 12, 2013

I have created a piece of code that filters a sub form of diary records using criteria the user has selected or entered. It was working fine when I made it a month or so ago and now is seems to be returning incorrectly filtered records, for example, I enter 2 dates to return all diary entries between the 2 dates. Yet it misses some records out that should be within the date range, and it sometimes include records that are outside the date range. I am also getting an error when I try and filter the diary entries via the supplier, "data type mismatch", here's the code that, bearing in mind, was previously working fine.

Code:
Public Function filter_diary()
Dim dbs As Database
'Dim qdf As QueryDef
Dim Sqlstr As String
Dim sqlstrwhat As String

[code]....

View 1 Replies View Related

General :: How To Import PST Outlook File

Jan 22, 2013

Is there a way to import a PST outlook file into Access 2010 or 2013. Or is there a Plug-in needed that can do it.

View 3 Replies View Related

General :: Outlook Emails Fail To Be Sent

Sep 17, 2013

I have an Access database update process that is run from the Win7 scheduler. I have attempted to instantiate or reference Outlook and send an email indicating the status of the process.

Outlook fails for some reason, but it works fine interactively regardless of whether Outlook is running or not.

I am now thinking of trying SendObject instead.

View 3 Replies View Related

General :: Create A New Outlook Email

Dec 12, 2013

I want to be able to click on a button on one of my forms and it create a new outlook email.I also want this email to have an attachment that is a report that I already have made.

View 1 Replies View Related

General :: Sending Email Through Outlook?

Oct 18, 2013

with the linking tables thing to outlook can it be reversed. ie if i have a table that was linked to outlook outbox would the records form an email just like the emails from my inbox form a record.

i wanting to send emails automatically to many recipients. so i would have to use a record set and i thought that if i build the email in a record then have outlook pick it up then that would be the easiest way.

View 2 Replies View Related

General :: Auto Fill Data From Outlook

Jun 6, 2013

Is there a way to auto populate a table or form in Access from an Outlook email? For instance, if I send a survey via email and the survey is taken and sent back via email is there a way to have that data auto fill into the database or will the info need to be manually data entered?

View 3 Replies View Related

General :: Setting Monthly Reminder Using Outlook

Jun 22, 2015

I'm working on an access database and I need to connect that database to the reminder function of Outlook.

At first, I set the reminder precisely six months before the due date, everything was okay and the reminder worked. But after some revision required by my supervisor, I need to set the reminder based on month (not exactly on the due date), so the tasks which have due dates in the same month will be wrapped into a single reminder. The reminder also should be appear in every two weeks. Here's the code I've been worked on :

Code:
Private Sub Expired_AfterUpdate()
Dim outLookApp As Outlook.Application
Dim outLookTask As Outlook.TaskItem
Set outLookApp = CreateObject("outlook.application")
Set outLookTask = outLookApp.CreateItem(olTaskItem)

[Code]...

I put this code on the AfterUpdate event in the column containing the due date. How should I rearrange the code so it would be able for the reminder to appear based on the month? (just consider that the reminder will be active six months before due date).

View 4 Replies View Related

General :: Add Outlook Entry To Non Default Calendar

May 2, 2014

I have a folder under the default on in outlook named ANOTHER FOLDER. All I am trying to do is add the blasted entry to this folder. At the moment though it is adding the information to the default calendar and not ANOTHER FOLDER. I'm just testing at the moment but I have tried all manner of combination but no dice.

Code:

'Error 429 occurs with GetObject if Outlook is not running.
On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If Err.Number = 429 Then 'Outlook is NOT running.

[code]...

View 11 Replies View Related

General :: Data Collection Using Microsoft Outlook

Jun 5, 2013

I want to use Access to collect data for our research department. I have created a number of forms to assist the department in collecting data. I created a query with all the fields from the relevant tables to be used to collect the data. I used the option Collect and Update data via email to generate the form for collecting the data and emailed the form to myself for testing (gmail account), however, I cannot edit any of the fields.

View 1 Replies View Related

General :: Duplicate Entries In Combo Box

Apr 21, 2013

I've got a combo box that lists duplicates. I want the dupes removed.

I went to the Query Builder for my Combo Box and set Unique Values from "No" to "Yes" - Saved, then re-opened the form. It still lists dupes.

I went back into Query Builder and unchecked the box for the Patient_ID (Autonumber) field. I saved it, then viewed the Datasheet for the Query, and it correctly lists the data I want WITHOUT dupes.

However, when I go to Form View, the combo box lists several blank entries..

The entries come back when I re-enable the Autonumber field in the Query.

This is what I currently have...

SELECT DISTINCT Patients.FullName FROM Patients ORDER BY Patients.FullName;

View 4 Replies View Related

General :: SendObject Outlook - How To Stop Getting Warning Messages

Sep 5, 2012

I am using SendObject to send Outlook email messages from my application. On my development system, I get two Outlook warning messages each time I send an email. A user tested this on the live system today and said they got no Outlook warning messages.

Is this something that I can set? To not give Outlook warning messages?

View 1 Replies View Related

General :: Outlook Event Based On Query Dates

Dec 2, 2014

I have a query that has some reminder dates. 10 days before an event and 5 days after. I was wondering if it would be feasible to create an outlook reminder based on the query and if so how would I go about it?

View 1 Replies View Related

General :: Send Emails From Run Time Version With And Without Outlook?

Nov 14, 2012

Must Outlook be installed for Access to send emails?

Can I send emails from the Run-Time version of Access? (with and without outlook)

View 1 Replies View Related







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