Outlook Address Book

Nov 11, 2008

I have an Excel form that requires the user to enter the name of their manager. Rather than entering the names manually I would like to use the Outlook address book but I've run into a dead end due to my limited knowledge.

Sub GetOutlookAddressBook()

Set appOutlook = CreateObject("Outlook.Application")
Set CDOSession = appOutlook.CreateObject("MAPI.Session")

CDOSession.logon "", "", False, False, 0

Set Recipients = CDOSession.addressbook(Nothing, "Select Distribution List Members", False, True, 1, "To:", "", "", 0)

View 9 Replies


ADVERTISEMENT

Using Macro To Find Email Address In Address Book Of Outlook

May 22, 2014

I am struggling to find a macro which can look at a name in column 'BT' and search it in the address book of Outlook to then place the email address of that person in column 'ED'

There are 35,000+ people in the address book and there may be over 5 email addresses for one name, so is there any way a message can appear for the user to select which email address is correct if there is more than 1 contact for that name?

View 1 Replies View Related

Get Email Address From Global Address Book In Outlook

Feb 25, 2014

On a worksheet called "Contact Info" column A starting in row 2 I have a list of names (variable length). In Columns B2-D I need the email address, work phone number, and cell phone number.

View 5 Replies View Related

Importing Outlook Address Book Data

Feb 20, 2007

I've had a scan through the archives trying to find a post or item on importing Outlook data to Excel, and have so far only found articles on importing data from users' 'Contacts' lists. I need functionality so that when the user selects an office (e.g. 'London') from a list, further details for those offices - which are stored as individual members of the global Outlook addressbook - for example postcode, can be operated upon.

Because this data is relatively dynamic (e.g. potential for relocation of office premises), I need any procedures to refer to a single unified data source, therefore I'd like any VBA procedures to use data directly from the outlook address book, instead of importing a static copy of the data and then performing operations on this.

View 3 Replies View Related

Read Details From Global Address Book In Outlook

Jan 22, 2010

I use the following code to read information from the Global Address Book in Outlook, and it works. Do any of you know how I can read the Email-address and alias-Name as well? By other word more information from each record. The code below will give me the name only.

View 4 Replies View Related

Txt Address Book

Aug 16, 2008

I have data like this:

Sammi Alvarez-Vegan

1201 E. Ponce De Leon Blvd.

Coral Gables, FL 33134

Angie Penns

6870 SW 44th Street

Building G28- #110

Miami, FL 33155

Some names and addresses are 3 lines and some are 4 lines. All have a blank line between. There is a double blank between different name blocks.

I tried to Concatenate so all parts would be in B1 cell. =A1&","&A2&","&A3&","&A4&","&A5&","&A6&","&A7

That did what I wanted for B1, and when I copied it down, B2:B8 was part of an address.

It was not until B9 did the actual next name come into play.

I know there must be a better way

I am using WindowsXP and Excel2007

View 9 Replies View Related

Make An Address Book

Feb 3, 2004

In Sheet 1 I have the Raw Data

with column headings

Name , Address , Station, Work Phone, Home Phone Mobile number

How can I make an address book in Excel

Suppose in the AddressBook Sheet

in A1 if we write the letter A the names starting with A will be displayed in Cell A2 Downwards along with the retreived information abt that recoreds Similarly In G1 if we write B then the recored starting with letter B should be retreived from the sheet 1 containing raw data in cell G2 downwards and this goes on in column M1=C S= D and so on

View 9 Replies View Related

How To Make Address Book With Userform

Aug 22, 2013

New to VBA, so here we go. I want to make address book with userform,is it possible with my example?

View 4 Replies View Related

How Can I Convert Web Address Book To Sheet

Jul 5, 2007

I am trying to take an address book on the internet and copy/paste it into excel- not hard right? Ok, so that is done. The problem I have is that there are over 2000 addresses- and they all copy straight down into one column. I know how to transpose the information- but come on- there are over 2000. that seems like a LOT of work. So my first question would be is there a way to do this all at once? For each company/name/address/phone I need one row per company.

View 9 Replies View Related

Reformat Address Book Layout

Mar 10, 2008

I have created a simple address book in Excel 2007, but it is not reader-friendly: My header row in Sheet1 consists of cells labeled “Category”, “Company Name”, “Street Address”, “City, State, Zip”, “Contact Person”, “Office Number”, “Cell Number” so the data for each company is listed in a single row. I would like to see if there’s a way that I can setup the workbook such that the data from Sheet1 automatically reformats into a directory-like format in Sheet2. Ie:

Company Name1 Contact Person1
Street Address1 Office Number1
City, State, Zip1 Cell Number1

Company Name2 Contact Person2
Street Address2 Office Number2
City, State, Zip2 Cell Number2

etc

Also, I would like to figure out a way to filter by the Category column, so that Sheet2 contains all items on Sheet 1 that are labeled Category A, Sheet3 contains all items on Sheet 1 that are labeled Category B, etc.

View 7 Replies View Related

Emailing Via Lotus Notes - Address Book

May 14, 2009

I'm trying to modify.

The code is this:
Dim finder As Object
Private Sub ComboBox1_Change()
Set finder = Sheets("Sheet1").Columns("A:A").Find(what:=ComboBox1.Text, lookat:=xlWhole)
Main_recipients.Value = finder.Offset(0, 1)
End Sub
Private Sub Send_email_Click()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With

Now, everything works fine until it gets to this line:-
MailDoc.SEND 0, Recipients

when I get an error message that states "Unable to send mail, no match found in Name & Address Book(s)"

In Lotus, I created a list of recipients (including any additions after the name) and copied that into the cell that feeds the text-box "Main_recipients".

The odd thing is, if I just email myself without any additions after my name it's fine. It's when I try to e-mail multiple people (with and without additions) that it falls over.

View 9 Replies View Related

Import Contact Info From Macro Address Book 4.0.6

Sep 6, 2008

At job, Mac OSX and Address Book 4.0.6 with contact info including in many cases emails. I'd like to get it of there, into Excel to manipulate, and ultimately into a FileWrecker Pro database. How to export 1087 entries from Address Book including only selective data fields is the question, and I know that's "slightly" OT, but I do want to import into Excel, so I hope that vindicates me! If not, and you can point me to a good MacForum, I'll settle.

View 9 Replies View Related

Excel 2010 :: Matching And Highlighting Addresses In Address Book

Apr 14, 2014

I'm using Excel 2010 and I have a copy of an address in Excel. I'm trying to identify all the people who live by themselves- without partners and spouses.

I have a column array like this:
A B C D E F G H I J K L M N O P Q R S T
PDENOStatusTitleFirst NamesInitialsSurnameSuffixDate of AttainmentFranchise FlagAddress 1Address 2Address 3Address 4Address 5Address 6Address 7Address 8Address 9Postcode

And the relevant columns is usually L. I am trying to figure out the formula that allow me to extract or at least highlight the people who live by themselves- or alternatively the people who live in the same house (which would therefore identify by exclusion the singletons).

View 1 Replies View Related

Excel 2013 :: Removing Extra Spaces Form Address Book

Jul 22, 2014

I have an Excel 2013 address book that has extra spaces between first names, last names and middle initials all in 1 cell.

Is there an easy way to remove all the spaces between these components?

View 3 Replies View Related

Outlook Address List Too Big

Apr 30, 2009

I am using this peice of code from another post in order to fill a ListBox with Outlook addresses. It works fine, but the the list has thousands upon thousands of names and it takes forever to run. I thought I'd add code to only add specific entries based on what a user inputs to a TextBox, but it doesn't seem to speed-up the process. how I can get to the user-defined data more quickly?

Private Sub CommandButton2_Click()
Dim olApp As Outlook.Application
Dim olNamespace As Outlook.NameSpace
Dim olItem As Outlook.AddressEntry
Dim olAddressList As Outlook.AddressList
Dim olAddressEntry As Outlook.AddressEntry

View 9 Replies View Related

Finding Macro To Copy Cells And Send To One Email Address In Outlook

May 17, 2013

I have a form in excel (very simple) that I need to put on the web - People can then fill out certiain bits of the information and the idea is that they then click on the button to email it back to me. Ie complete it there and then and email it straight away so that they don't need to save it etc.

I can't for the life of me work out how to do this! I've managed to get the macro to open an email with the correct details on but not paste in the information so am at a complete loss and appear to be going round in circles!

View 2 Replies View Related

Move All Worksheets From Book B Behind All Sheets In Book A?

Jul 18, 2014

I made the following code to merge 2 workbooks together.

The code is to be executed when the user has Workbook A opened. (All sheets in workbook KPISWD are supposed to be moved after all worksheets in workbook KPICustomers).

I keep getting a debug error on the code that is supposed to do the actual move and loop until it is finished with all of the sheets in Workbook B.

Code:
Dim KPICustomers, KPISWD As String
KPICustomers = ActiveWorkbook.Name

Workbooks.Open Filename:= _
"W:FacturatieKPI per periode SWD.xls"

KPISWD = ActiveWorkbook.Name

[Code] ..........

View 3 Replies View Related

Copy Data From Book To Book Error

Jun 22, 2007

I have the below code, which now looks to see if a file is open or not, if it is, then copy and past 'Data' and if not open the book and copy 'Data'.

I think the code is sort of right, but im missing something, as i keep getting runtime error when i try and copy. Here is the
Sub PrintSaveKPIUpdate()

Dim sFilName As String
sFilName = "C: estCashSales_KPI.xls"
Set Main = ThisWorkbook

If IsOpen(sFilName) Then

' Book is Open.

Worksheets("Setup Data"). Range("Data").Activate

View 9 Replies View Related

Call Macro In Book Two From Book One

Aug 29, 2007

i have done a search on this topic and found many similar answers to many similar questions. All specify using Application.Run "workbookname.xls!macroname".

In my code, the filename has an assigned value as the master code goes out to many secondary files - the user selects the particular one they want at the start of the macro. The variable assigned is called "UpdateKAMsFile".

how do i get the macro called KAMsRandomColour to run in the workbook designated by UpdateKAMsFile?

View 9 Replies View Related

Macro To Highlight Data Inside Other Data Or Move From Book To Book

Jul 16, 2014

so to start off im not able to attach things due to security reasons, what i need is either 1 of 2 macros. if its possible, both are related. one possible is as follows: i need it to go through a certain column (say I for example) and look at the information in it, this information can vary from peoples names along with dates and other stuff, i want it to look through these and if anything has a date today and prior i need the cell to be highlighted. problem is sometimes it might have 2 dates, or no dates. it should have todays date, their name, other information, and future date of something. but not everyone does, this is the macro i dont think that can exists.

2nd macro possibility the other macro uses the first sheet, AFTER been highlighted, normally by hand, and takes it to another workbook and puts in in certain spots. so the first sheet has names of everyone in column K. what i need is it to look at column I and if its highlighted take entire row to other book, and put into sheet under the person name in their tab. the second book has a tab for each person (at this time 18 tabs) which can fluxuate, and each tab is the persons first and last name, without spaces. since when i put sums on main page it didnt want to work with the spaces i had to omit them. again im not sure this is possible.

View 6 Replies View Related

Copy From One Book To Another Tab On Another Book

Aug 20, 2009

I would like to know if there is a way to copy a spreadsheet and paste it into a new tab on another spreadsheet. We currently download 2 lots of spreadsheets from SAP and would like to create another spreadsheet to act as a 'central' preadsheet. What I would like to happen is that the data from the 2 downloaded spreadsheets will be automatically pasted into 2 new tabs on the central spreadsheet, then run some formatting macros (which I can do fine).

View 3 Replies View Related

Need To Pull Street Address Out Of Full Address In A Cell

May 20, 2014

Assume the following list of addresses are all in separate cells of a single column (A1-A4). I just need the formula to extract the street addresses, and then a separate formula to extract the zip codes.

5430-44 PASCHALL AVENUE PHILADELPHIA, PA 19143 OPA/BRT#: 884350845

4010 MARPLE STREET PHILADELPHIA, PA 19136 OPA/BRT#: 651087200

2618 SOUTH HOWARD STREET PHILADELPHIA, PA 19148 OPA/BRT#: 391251216

5737 WOODCREST AVENUE PHILADELPHIA, PA 19131 OPA/BRT#: 522155600

View 2 Replies View Related

Split Address Which Is In Single Column Which Contains First / Last Name And Address Without Any Comma?

Apr 24, 2013

I have a list for addresses in excel in single column as shown below - aanandhi narayanan 3430 chemin de riviere sanjose,CA95148

DOMINIC ABANO 3838 GLENGROVE WAY SAN JOSE, CA 95121

abdi abdi 5390 monterey rd #6 sanjose,CA95111

Sheribel Abinsay 3212 Gateland CT San Jose, Ca 95148

I need the result to be in a way like -

3430 Chemin de riviere
San Jose
CA
95148

3838 Glengrove way
San Jose
CA
95121

5390 monterey rd#6
San Jose
CA
95111

3212 Gateland CT
San Jose
CA
95148

I have around 12000 records with the same format.

View 9 Replies View Related

Book Using Too Much Memory?

Dec 23, 2013

I have a large amount of data on NBA teams and players that is extracted from external web pages. In order to have the data shown on separate sheets to do comparisons I have to use many array formulas and from what I have read that takes up a large amount of memory. I'm now at the point where I'm receiving a message that says "Excel cannot complete this task with available resources" when I open the workbook.

Is there any plausible way that I can resolve this situation? I have thought about converting the lookup formulas from arrays (index/match) to vlookups and hlookups.

I'm not as advanced with using Excel as most of you, and I realize I may be at a point to where I will need to use different software to analyze my data, but I would prefer to stick with Excel as it would be difficult to start from scratch and learn how to use a different program.

View 3 Replies View Related

VBA Book For Beginners

Sep 8, 2009

I am looking some suggestions for a good book i can buy online to learn about writing VBA for excel. I find this forum very useful for help on solutions to write VBA code but i would like to learn the basics so i can understand what it is i am adding into my excel files. Moderators... If this breaks the forum rules (i've read them and can't see anything).

View 3 Replies View Related

Copy From One Book To Another

Sep 30, 2009

I Have been working on a spreadsheet for attendance recording. I will be keeping a new one for each month. I need to be able to take accumulated data from one book and put it in the new one. I have the Following

View 2 Replies View Related

Vlookup From 1 Book To Another

Sep 11, 2009

What do I need to do to get my vlookup formulas to look into another workbook(or excel file) without having to open it up.

Here is a sample of formula that I have:

[=IF(C13="","",VLOOKUP(C13,Data,21,))]

View 14 Replies View Related

Set Variable As Book Name

Aug 14, 2006

I am generating Excel reports (with different names) using VBA. The problem I'm having is that for a certain macro, it needs to create a new book, and then activate the original window. But because all the new reports have new names (but using same macros), the name written in code doesn't equal the book's new name. How can I set a variable to be the book name? I do know that the name of the original book will be equal to two letters plus the value in A7. The problem is this: I have written a macro that shows the following

Worksheets("Sheet2").Select
Workbooks.Add
Windows("FT Bi Test.xls").Activate

I need something more like this (though this exact code doesn't work):

Worksheets("Sheet2").Select
Workbooks.Add
Windows("FT " & Range("A7").Value ".xls").Activate

Or something like this:

Worksheets("Sheet2").Select
Workbooks.Add
Windows("FT " & Variable ".xls").Activate

View 6 Replies View Related

Book On Programming

Jun 19, 2008

I have only the basic knowledge of the VBA programming. Are there any books you can recommend?

View 2 Replies View Related

Get Open A Work Book

Aug 21, 2009

how to get excel to open a work book in my c drive if i have given it the location in cell m2

eg: the cell is M2
C:AVERAGE PRICE (update 2009) 240809

i need the macro to open this workbook when i click the button in the workbook i have open that has the above in cell M2

View 3 Replies View Related







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