I have a form with a email field containing a email address, I would like when clicking on it this will open OUTLOOK 2003 placing the email address on the "TO" field
I have looked around but I have not find what I need, I had a VBA code but this will open me a web page instead of OUTLOOK.
Can I get some help!
Thanks
M.
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
when trying to automatically send email through MS Access application, the following message appears:
"a program is trying to access e-mail addresses you have stored in Outlook and asking if you want to allow this"
"a program is trying to automatically send e-mail..."
How to disable these warning messages when executing MS Access application to send email?
THANKS
I'm using an unbound text box and a command button to filter a list of contacts on a continuous form. The continuous form has a query for the record source and the list ends up showing only what is in the strWhere filter
Me.Filter = strWhere
Me.FilterOn = True
Is there a way to have Access 2003 take this filtered list and populate the To: field in Outlook or whatever the default mail client is? Each email needs to be deliminated by ";"
I am opening a new mail message in outlook using a button in a form.I want to change the "from" email address to a specific inbox (NOT personal email). Even though the email address is switched, after I hit sent and check my sent items - the email is actually sent from my personal email address and not from the inbox email address i wanted it to be sent from. I have access/permission to sent emails from the other inbox.
Is there a way to make sure emails are sent from specific email addresses and not ONLY personal inbox.What I read online is probably because of some "network" connection issues. Is there a way refresh connection between access and outlook? I am not even sure what the problem is.
Hi experts in MS Access!
Need to know if I can open a MS Access 2000 (large) mdb-file in MS Access 2003 Professional without loosing any functionality? Is there a working way around this behaviour of MS Access 2003? It seems now, when comparing from MS 2000 openings some functionality got loose when I open the same 2000 file in Access 2003. Working environment is MS XP professional and all security patches for Office 2003 Pro and XP are applied.
Regards.
Engstrom
Hi m8
I have Microsoft Access 2003 which is running fine. I have setup ODBC source through windows xp Professional control panel.
While i am in access application and try to open by selecting
File/Get External Data/Link Tables
It open Link PopUp Window, then from the Files of type drop down, I select ODBC Database(). Windows just disppear, not opening odbc source selection
window.
Please could you help me, why this is happening and sort it out.
Many thank
Hopefully this is pretty simple.
Have an existing app. When I open it from within Access the app seems to go into some runtime mode ... shows a splash screen, menus, etc.
Okay how do I go into design mode so I can modify it ?
Yeap am a complete newbie with Access and haven't touch since the Office 97 version :o:eek:
Not sure if you are meant to ask multi questions in one thread, or create a thread for each one. Will created a new thread for my other question, so if one of the Mods could point out the correct way of doing this would be appreciated.
hello good afternoon.
i am trying to open different file types using ms access. the following piece of code i found would only open 'word' documents. how do i make this piece of code more flexible to open pdf documents and excel as well. as it is currently i have a txt field on my form and if the path in the txt fiels leads to a word document when i click a button the word file opens. i want it to open a pdf or excel doc if it was in the txt field
[code]
Sub OpenWordDoc(strDocName As String)
Dim objApp As Object
'Opens the document
Set objApp = CreateObject("Word.Application")
objApp.Visible = True
objApp.Documents.Open strDocName
End Sub
I have designed a DB in access 2010 and it opens fine on my computer. However, when others I work with (who still have 2003) try to open the database, they get the following error: "An Error Has Occured Trying to Load The Form "Form Name" - Do You Wish to Continue".
When I click Yes, it brings up all of the VBA code in the background, but when i close all of that out, it still doensn't open.I am by no means an access expert.
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
Hi All,
Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.
Thx,
Jatz
I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???
View 6 Replies View RelatedCan 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 RelatedHello,
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:
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...
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.
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
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.
um..
help please
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 RelatedHey 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
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