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
Hoping someone can help - need to know if there is a way to use a Outlook message other than the blank one that is used with the send object macro.
Maybe a normal message with a signature, template or something - when the macro is run, no formatting is included with the e-mail message, and the body of the message is limited to 255 charaacters.
Would like to use a customized message, and I need the send object macro to place the object in that message format.
If anyone can help, I would greatly appreciate it...thanks.
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.
I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro.
Here is the code i am using at the moment, all I want to do currently is click the first button, then get the second macro to execute. But no luck, getting error 2157 "cannot find the procedure"
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:
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.
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...
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?
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.
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
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.
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??
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!?
In the outbox, there is an email i tried to send many months ago, and now everytime i try to go back into the outbox where this message is, it freezes the computer. My inbox is still functioning fine, but the outbox problem means i have to crtl/alt/delete to exit from my outbox everytime.
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?
