Forms :: Easy Way To Use Microsoft Outlook Address Book To Populate A Drop Down Combo Box?

Aug 6, 2014

Is there a quick and easy (or not so easy) way to use Microsoft Outlook Address Book to populate a drop down combo box? I am creating a form that needs to pull in Business Process Owners, all of which would be in our corporate address book.

View Replies


ADVERTISEMENT

Address Book

Oct 12, 2006

I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx

View 7 Replies View Related

Address Book

Oct 12, 2006

I have a form "frmsend mail" whic have fields "To" and "Cc" i want to have a address book in the access itself having same functionality as outlook i.e it should add new email id to the address book, prompt the email id,etc.
How to do tht.
thnxx

View 1 Replies View Related

Forms :: Populate Field With Drop Down List

Oct 25, 2013

Is there a function that will populate a field with drop down menu based on two criteria?I want the the fields with first and last name to populate with drop down lists based on the employee code I have inputted in the form and job title from a query.

Path: looks at employee code from form > looks at specific job title from query > pulls out all first names in one field and all last names in another field with the same job title in drop down list from query

Employee Code: 100

Returns all employees' first names in first field with same job title:

Prince
Tina
Greg

Returns all employees' last names in second field of form with same job title:

Fey
William
Jones

Here's what the query looks like in datasheet view:

Code:
Location # First Name Last Name Job Title Employee Code
1 John Smith Technician 100
2 Jane Doe Manager 100
2 Greg Jones Engineer 100
1 Prince William Engineer 100
1 Tina Fey Engineer 100

I've been trying to get dlookup to work, but no luck. Here's one of my formula:

Code:
=DLookUp("[Last Name]", "[Employees tb]", _ "[Employee Code] = Form![Employee Code]" & "[Employees tb]", _ " [Manager]"
SELECT EmployeeCodeONLY.[Employee Code] FROM EmployeeCodeOnly;
SELECT [Employees tb].[First Name] FROM [Employees tb] WHERE ((([Employees tb].[First NAME])=[Forms]![Form1]![Employee Code]));

The first is linked to a separate table that only contains employee codes because query I am working with has duplicates due to multiple records.The second is trying to link both the table and query together to populate only first name.how to include the second criteria, job title, to refine it more.

View 1 Replies View Related

Forms :: Drop Down To Populate Data To Subform

Dec 15, 2013

I have:

Tables: Customer and Orders

Relationship: Customer ID is the primary key in Customer and is a foreign key in order table.

I need to create a Form with contains all the customer info from the customer table, as a drop down list. Once the customer is selected, all their orders should appear in a subform. At the minute I can get a form to work which shows all the orders but you have to go to the next record so see the order. For example it will say John smith and one order. The next record will be John smith again and their second order in the sub from.

I have used access in the past and I am fine with creating everything apart from the drop down. I am just a bit lost with the structure.

View 2 Replies View Related

Forms :: How To Auto Populate Fields After Using 3 Drop Down Menus

Jul 24, 2014

I have made a database. I have gotten to the point where I use a form to get the information. I am trying to get the information to auto populate fields after using 3 drop menus. They are department name, shop and shift. All of the information comes out of tbl department name, tbl shop and tbl shift.

I also have a table with department name, shop, shift, line, employee total, shift leader total, ratio of shift leaders per line and total employees off. I am trying to figure out once use the 3 drop down how can I Auto populate the remaining fields. Also I am trying to figure out where and how to put in the code.

View 1 Replies View Related

Forms :: How To Populate Subform Fields When Drop Down Selected In Main Form

Mar 12, 2013

I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at the moment, that for example, when a certain course is selected, that their modules will appear in the subform. Where my problem arises is that I have a relationship between two tables that I want to appear on the subform, so that details can be filled in on the subform against the list of modules that automatically appear.

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

Modules & VBA :: Search Outlook Exchange For Email Address

Dec 3, 2013

I'm trying to see if can search outlook exchange from access vba to get email address (using windows user name) .

View 1 Replies View Related

Modules & VBA :: Adding Email Address To TO Field In Outlook

May 2, 2014

I have vba code set up to automate a query output to email with outlook. I am having issues with the "TO" field. I have tried different types of code, such as the following:

1) MyMail.To = MailList.Fields("EmailAddress")
2) MyMail.To = MailList.Fields("EmailAddress") & ";"

Both of these work, but the issue I am having is the "TO" field in the outlook message looks like this:
admin@blahblah#mailto:admin@blahblah#

Why my code is adding the email address twice, I need to get rid of the #mailto:admin@blahblah# but I do not know how or why it keeps adding that end part.

View 3 Replies View Related

How To Tell Access To Pull Email Address From Outlook Instead Of Display Name

Oct 15, 2013

I'm working on a database which holds information about clients. This also has a linked table which pulls information from my outlook inbox. Basically what I want is a way to sort the emails into the appropriate contacts page. I have created a sub form which is linked to the contact form and pulls info from the email table. The sub form is linked by the 'from' field in the linked email table to the 'email address' field in the contact form.

This all seems to work exactly as I want when the email address is displayed as the display name of the client however most of the time, the display name in outlook is either the contacts name or their company name.

I suppose my question is this, how can I tell access to pull the email address from outlook instead of the display name? I may be missing something here but this seems like something that should be available as standard doesn't it?

View 13 Replies View Related

Forms :: Populate Combo Boxes With Values Depending On Selected Value In Previous Combo Box

Aug 5, 2013

I have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.

Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...

View 1 Replies View Related

How To Setup FROM Email Address When Opening Outlook Through Access Form

Dec 9, 2013

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.

View 1 Replies View Related

Modules & VBA :: Export Email Contact Address To Outlook Using Access 2003

Feb 3, 2015

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 ";"

View 5 Replies View Related

Open File Msg (outlook) From Access With Double Click On Email Address

Mar 15, 2012

In an ACCESS DATABASE I have 2 fields

-email_address

-language

I want make double click on email_address field and open a specific files msg

example :

double click on gimec.roberto@gmail.com

if the language is ITALIAN open in OUTLOOK file ITALIAN.msg

if the language is RUSSIAN open in OUTLOOK file RUSSIAN.msg

View 1 Replies View Related

How Can You Use Drop Down Combo Box In Forms

Jul 4, 2005

Hi I'm a beginner using access and I was wondering if it's possible to choose a value from a combo box in a form (like a customer #) and when chosen the rest of the fields would get the corresponding values from table CUSTOMER. I have made the customer info a sub-form in my main form called ORDER your help will be greatly appreciated

View 2 Replies View Related

Modules & VBA :: Send Meeting To Outlook - Address Item Line Causing Error

Mar 24, 2014

I'm trying to have a command button send info on the form straight to Outlook as a meeting. So far, the code below works apart from the address bit. I need the code to automatically add the same 2 email addresses as recepients everytime.

Error message highlights the red line below with the following message:

Runtime error '438'
Object doesn't support this property or method

I'm new to VBA, so don't understand what is wrong here. The reference is set, I've tried different permutations of the "To:" & "Recipients.Add" for the email address with no joy.

Code:
Private Sub cmdSend_Click()
Dim outApp As Object
Set outApp = CreateObject("Outlook.application")
Set outmail = outApp.CreateItem(olappointmentitem)

[Code] .....

View 10 Replies View Related

Forms :: Combo Box Drop Down Search

Jun 27, 2013

As an example lets say I have a table listing some cars:

Car Make Car Model
Ford Fiesta
Ford Focus
Ford GT
Mercades C Class
Mercades E Class
Mercades A Class

I am making a form with two combo drop downs with the ability to select car make or model.

Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box

however, If i select "Mercades" for example in the car make, I would like the combo box of Car model to only be filled with the possible models that Mercades make.

Is this possible? (to search for the values available in Car Model based on the value entered in Car Make?)

View 1 Replies View Related

Forms :: Align Combo Box Drop Down Text?

Mar 20, 2013

it possible to align the row source values of a combo box? i want to align it to the right instead of the left

View 2 Replies View Related

Forms :: Displaying Initials In Combo Box When Option Selected From Drop Down

Oct 2, 2013

I have a Combo Box bound which gets its values from a table (T_Users).

The Combo Box displays the Users 'Initials' [Column 1], but the Bound Column [Column 2] is that of the Users 'ID' (which is used when a record is edited or a new record added).

What I want to be able to do is when the user clicks the Combo Box, and the drop down list 'drops down' the options, I want them to not only see the 'Initials' but also selected other columns - BUT - when the option is selected I just want the 'Initials' to be displayed in the Combo Box.

Code:
So, Normal > | ABC |

Dropped Down > | ABC |
--------------------------------------------
| ABC (Annabel Carcus, Big Company Ltd.) |
| JB (Joe Bloggs, Medium Company Ltd.) |
| FS (Fred Smith, Little Company Ltd.) |

Select JB, and > | JB |

View 6 Replies View Related

Forms :: How To Filter Reports By Date Types In A Drop Down Or Combo Box

Jun 26, 2013

filter reports by specific date types in a drop down or combo box I would like the dates to be

Today
Tomorrow
The next 3 days and the next 7 days

i don't want a date picker or between dates I have tried searching but cannot seem to find an answer They are for my engineers, they want to know what callouts they have today or tomorrow or the next 3 days or this week.

View 3 Replies View Related

Populate Outlook Calendar From Access

Jul 10, 2013

I've created a db for a group working on the repairs needed after Super storm Sandy. In the db I have captured arrival and departure dates of work teams coming in to support. How I can populate an Outlook calendar from the db table?

View 5 Replies View Related

Access 2010 - Auto Populate Correct Persons Email Address

May 1, 2014

I currently have a database set up with three basic forms:

Form 1 = Main menu with options to go to Form 2 and Form 3

Form 2 = Employee information form which includes email address

Form 3 = Employee document upload form

My goal is once the Employee is registered in Form 2 they can then upload a document in Form 3. When they upload this document and fill out other parameters Including their bosses name (which is captured as a record in Form 2) they click "Submit Form." I would like for this submit form button to populate an email that is updated to send to the selected "Bosses name"

Currently on the Submit form button I have:

Private Sub Submit_Record_Click()
DoCmd.SendObject _
, _
, _
, _
"email .com", _ <-- this is what I want to autopopulate with the correct persons email (as well as their name below)
, _
, _
"***A new Lab Report has been submitted for your review***", _
"Bosses name," & vbCrLf & vbCrLf & vbCrLf & "Please log into the Report Database and review the latest pending report. If you have any questions please contact the sender." & vbCrLf & vbCrLf & "This is an automated response generated from Microsoft Access." & vbCrLf & vbCrLf & vbCrLf & "Sincerely," & vbCrLf & "ESBU Lab Report Database", _
False
DoCmd.Close
End Sub

View 1 Replies View Related

Forms :: Combo Box To Populate Text Box

Dec 10, 2014

I am newish to background coding in access 2010. I have a call log with a form which is where the information on the caller/area is entered. There's a combo box that needs to populate a textbox with 3 different things, depending on whats selected. I'm using If,Then, Else.

The first selection needs to just have the textbox say something. I have that figured out with:

If Me.CboSource = "..." Then
Me.Title = "..." (cboSource = combo, of course, and Title is the textbox.)

Next is where I'm fuzzy....The second selection needs to have the textbox populate with a dropdown list of choices from another table. No matter what I do, nothing is working. My latest attempt is:

ElseIf Me.CboSource = "External" Then
Me.Title = [tablename].[name]

View 10 Replies View Related

Forms :: Lookup Table To Populate Combo Box?

Sep 2, 2014

I'm using a lookup table to populated a combo box on my form. I use a provided list of input strings (hundreds) in my combo box and the list is provided in all caps. How can I convert these provided words (strings) to first cap from either the quarry level or form level.

View 1 Replies View Related

Forms :: Combo Box / Text Box Auto-Populate

Oct 14, 2013

I have 5 combo boxes that all cascade into the next, and then when the last combo box is updated from the drop down list, it auto-populates a text box. My issue is that I have a second text box that needs to be auto-populated from the same data table based on what has been entered into the 5 combo boxes and the first text box. I've tried creating parameters and setting a lookuprecord macro in my main table and then using a returnvars RunDataMacro on the actual form, but it says, "Invalid list or query reference 'BillingDataQuery'." I'm not sure if it's because I'm not setting that RunDataMacro on the wrong combo box, or if I've written it incorrectly...

I did this same technique (based on directions in a post from this forum) on another combo box that populates five text boxes and it works just fine, but I don't know how to get this to work based on what's populated in 5 combo boxes to auto-populate the last text box.

View 3 Replies View Related







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