General :: Use Outlook In VBA?
Feb 3, 2013I 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 RepliesI 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 RepliesIs 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 RelatedI 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.
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 Relatedwith 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.
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 RelatedI'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).
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]...
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?
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 RelatedMy 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?
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?
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 RelatedMust Outlook be installed for Access to send emails?
Can I send emails from the Run-Time version of Access? (with and without outlook)
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 RelatedI 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 RelatedI created a call logging/work tracking type Database using SharePoint 2007 lists for the backend and Access 2013 front end for about 60 users and it has been running smoothly for around two years .
We use a shared outlook calendar and I want to be able to pull meetings & appointment information into the database from the calendar so I can assign the meetings out to specific people and keep of a record that they where given the request to attend. I was able to use the import outlook folder to create a linked table and it has lots of great information from the calendar apart from the two most important things you need in a calendar Start_time & End_Time . Is there something I'm missing in regards to these two fields? I assume I'm doing something wrong but I can't figure out what, nor did I have much luck with the Search function on here or google.
This is the list of field names it does import(everything apart from the meeting time and is it a recurring appointment)
Importance
Icon
Priority
Subject
From
Message To Me
Message CC to Me
Sender Name
CC
To
Received
Message Size
Contents
Created
Modified
Subject Prefix
Has Attachments
Normalized Subject
Object Type
Content Unread
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?
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 RelatedI have been looking for a way to sync a table holding reservation dates to MS outlook calendar automatically when dates are inserted in the table.
View 2 Replies View RelatedI'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.
I have a database that I can use to create a query, grouping companies by city. I then want to send a specific email I have created in outlook to all of the email addresses in the query.I do not need to include names.
View 6 Replies View RelatedI 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.
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.
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.
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