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
ADVERTISEMENT
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
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
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
View Related
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
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
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
Jan 9, 2014
I am working on an email marketing project and i have a small problem. I have two different email list. One (List A) is a large list of potential leads. The other (List B) is a list of leads we are not supposed to market to. I need to delete every lead on List A whose email address is also in List B, so that we do not send unwanted emails to our clients.
The best way i have to do this so far is to go through line by line, which is very impractical.
In case it matters here is out list format. Each list has 10,000 + leads. Each lead occupies a row. The row stretches across 13 columns and each column holds a different variable about the lead (names, state, email address).
View 2 Replies
View Related
Nov 27, 2006
I want to email with excel, and I know how to do it if I have a distribution list already set up in outlook. I want to avoid having this DL in outlook though, and instead keep a list in the actual excel workbook. I tried having the list and then combining all the cells with a semicolon inbetween the addresses into one single cell, then assigning that cell to a variable and inserting it in the cose in place of the DL name, but it doesn't work. Apparently you can't mail to mutliple address thru the VB code, either a single address or a DL. Am I incorrect in this? So I thought maybe I could somehow create the DL first using the names in the list thru code, and then using that DL name to send the workbook.
View 9 Replies
View Related
Jan 2, 2014
I would like to generate a blank email with a list of recipients (no more than 40) in the 'To' field. I would like to do this in a single click on a cell with the text 'newsletter group' in it (cell B17). The recipients email addresses are in the format of one complete email address per cell in a column starting at C17 (C17, C18, C19, etc...). I thought I had found a way to do this (using the hyperlink function I think, but can't quite remember)but it turned out you could only string together about 8 email address before the function stopped working.
Also just to be clear, I don't want to send the workbook to the recipients.
View 4 Replies
View Related
May 31, 2009
I'm using Excel 2007 and have created a spreadsheet for invoicing. I have created a dropdown list which then imports the address data using vlookup.
My problem is this. If there is no text in say, address field 4 the resulting field in the invoice shows as a 0 eg,
NAME
ADD1
ADD2
ADD3
0
POSTCODE
Is there a way to move the Postcode to the empty cell showing 0? and/or how do I make the cell to show blank instead of a 0.
View 6 Replies
View Related
Jun 3, 2006
I have a wedding list of names and addresses in one long column. The names occur every 5th line. They are not in alphabetical order.
View 9 Replies
View Related
Jul 26, 2013
I'm trying to copy a list of addresses from a website and paste that into Excel. I'm having problems because Excel doesn't separate each address. The original website address list has clear separation of addresses (returns, tabs, etc). For example:
John Doe
111 Fox Street
Van Nuys, CA 91403 (See there's no separation between addresses)
Michael Smith
2759 Apple Street
Encino, CA 93727
This is the website where the address list comes from: [URL]....
View 14 Replies
View Related
Jun 19, 2014
I am trying cut and paste a list into Excel, and have Excel separate the different fields for me. There are 12 lines per each entry on the list. I use Firefox as my browser, and when I cut and paste using Firefox into Excel, this is how it looks:
James H. Patel, MD
(space)
Pediatrician
(space)[code]....
I'm hoping for the final product to look like this:
Last Name----First Name----whether MD or DO----Street Address----City, State, Zip code----Zipcode(by itself)
View 6 Replies
View Related
Feb 21, 2014
I am trying to see if an email address matches with a list of names in a worksheet. If so, it would proceed with code. For example, I have an email address 'middlesburg.john@gmail.com' that we get through an input box and in the list, we find John Middlesburg. Since it is obvious that John Middlesburg is middlesburg.john@gmail.com, how can I get it to go on through?
View 4 Replies
View Related
Jun 1, 2007
[code]...
The above is basically an action list showing who needs to do what. Each row in the list has a task and an assignee and the assignee's email address
I want a macro (that will be attached to a button or text in column H) that will copy that entire row (as well as the headers in ROW 4) and email that info via the default email application being used on the users PC (most likely to be MS outlook). i.e if i click on the button or text in column H for Task A (Row 5), an email will be sent to JB@excel.com (column G), for Task E (Row 9), an email will be sent to TB@excel.com,...etc.
I would prefer it if the info was sent as the actual message in the email instead of an excel attachment.
View 9 Replies
View Related
Apr 10, 2009
I'm looking for a way to convert an old church address list that is formatted in a single column. There are no blank rows, but the amount of rows for each entry can vary. For instance, there could be as little as 3 rows of data (church name, address, city/state/zip) or more if email addresses and websites are provided.
The data is currently in the format below (notice how one entry has a website while the other does not).
First Church
102 Main Street
Dallas, TX 12345
email@whatever.com
Second Church
500 Second Street
Austin, TX 12376
email2@whatever.com
http://www.boguswebsite.com
So I'm looking for the data to be formatted like the following:
First Church 102 Main Street Dallas, TX 12345 email@whatever.com
Second Church 500 Second Street Austin, TX 12376 email2@whatever.com http://www.boguswebsite.com
I was able to find the following code from a Google search, but it can't dynamically adjust the range.
Sub x()
Dim rng As Range
Set rng = Range("A1").Resize(5)
Do Until IsEmpty(rng.Cells(1, 1))
rng.Copy
Cells(Rows.Count, "B").End(xlUp).Offset(1).PasteSpecial Transpose:=True
Set rng = rng.Offset(5)
Loop
End Sub
I think what I need to make this code work is a way to dynamically adjust the range so that it can determine when to move to the next row of data. Static ranges break the process due to the amount of data being provided not being uniform. What I was thinking is that I could use the word "church" as a start point and end point in a loop so the script knows when to jump to the next row and begin copying the proper number of columns. I'm just not sure how to accomplish this in vba.
View 9 Replies
View Related
Mar 7, 2013
My problem has to do with an list of over 22,000 addresses (don't want to think about going through it manually )
The names are in column A and the addresses are in column B. The problem is, is that some of the addresses fit in one cell and others are spread over two (Oklahoma City, OK in one cell, 73034 in the one below it, for example.)
The names with corresponding addresses taking up two squares have been placed in merged cells, so that they line up with their addresses. Here is a picture below.
Capture.PNG
What I need is each address in one cell next to its address in one cell (to make it searchable, etc.) I thought I was being really clever when I copied Column A, then pasted the formatting onto Column B (so that the cells would be 1:1, one name cell, one address cell) but didn't realize I would be losing the information in the cells being merged.
View 5 Replies
View Related
Mar 11, 2013
I have a data set for over 9000 addresses and can't get it formatted the way I need to. Attached is a small version of the doc. I need colums with "Name, address, zip, state, etc." and need to get rid of any duplicate addresses. address mock1.xlsx.
The main issue i'm running into is some of the addresses are 3 rows, some are 4 or 5. If there is a way to group all the data automatically between the "----------------------" that seperate them I think the offset or concatenate tools might work?
This document was originally wordpad in this form and I don't neccesarily need all the data, mainly need to make a mailing list. address mock1.txt
View 2 Replies
View Related
Nov 22, 2007
I've been given a long list of mailing addresses in Excel in formatted as a single column, each address using three rows with no blank rows. Example:
John Doe
123 Maple St. #2
Cambridge, MA 02139
Jane Smith
321 Elm St. Apt 24
Austin, TX 34557
etc.
etc.
I need to get this data into the form ...
John Doe 123 Maple St. #2 Cambridge MA 02139
Jane Smith 321 Elem St. Apt. 24 Austin TX 34557
I would think this has been done, but I've searched the web and this forum without success.
View 3 Replies
View Related
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
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
Sep 6, 2009
I was reading http://www.excelforum.com/excel-prog...-in-excel.html And would like to give this a shot. So if you can school me a bit more on it.
Ok my cell provider is Vodafone Australia. (I cant seam to find any info on if they provide this service in australia)
http://www.microsoft.com/downloads/d...displaylang=en From reading this it uses the phone that is concted to the computer(my case USB).
View 6 Replies
View Related
Oct 30, 2007
I have searched and think I have found what I need to create Outlook tasks from my Excel spreadsheet. I'm hoping that someone here can help me pull it together into something that will be usable in my project tracking spreadhsheet...
I try to keep track of milestones... these milestones are listed in column B of my spreadsheet and are in rows 10 through about 105
For each of my customers I then keep 4 columns D, E, F, G - H, I, J, K - L,M,N,O - etc. Each group of 4 is a different customer....
The customer's first column (D, H, L, etc.) is a Due date of the Milestone that is found in column B.
The second column is a check box that I use to indicate when the milestone is complete
The 3rd column is the completion date
The last colum is just a filler space that helps to separate each customer.
What I would like to do is insert a button at the bottom of EACH grouping of 4 that when pressed would look at the first column for the customer group and for ANY Milestone that has a DUE date process the stuff in the VB below to create an OUTLOOK task for each item that has a DUE date. (It would be conceivable that as it stepped through each row for a customer group of columns that I could have it create 90+ Tasks in Outlook.
A couple of additional things... in row 110 for the first column of the customer I have a DATE or a blank. So for example in D110 it might be blank or a date like 10/29/2007. If it is blank then when I press the button it would loop through ADD the tasks for each row with a due date. If row 110 has a DATE I would get a popup indicating that the tasks are already in OUTLOOK and that they were added on whatever the date is in row 110... This is kind of the safeguard that I don't get the same group of tasks multiple times by pressing the button by mistake.
View 11 Replies
View Related
Nov 17, 2008
Is there a possibility to run an Outlook Calendar in Excel via code? and share it between users.?
View 2 Replies
View Related
Jun 18, 2009
In Excel, I want VBA to refer to the SENT ITEMS folder in Outlook. I want to loop over all sent items, and if the email address satisfies a condition, then record that fact in Excel. I am good at VBA in Excel, and I have a passing knowledge of VBA in Outlook, but I don't know how to refer to Outlook within my Excel VBA.
View 2 Replies
View Related
Jan 20, 2010
I want to use excel to update the tasks in outlook. All I have is a due date (from A2) and a task (from B2) Here is the code I have got so far
View 2 Replies
View Related
Feb 13, 2007
I have vba code that opens Outlook so I can run code to send emails...
Application.ActivateMicrosoftApp (xlMicrosoftMail)
But I don't want it to be visible, I want it to be minimized.
If I try:
Set olApp = CreateObject("Outlook.Application")
olApp.WindowState = xlMinimized
I get an error "Object doesn't support this property or method" referring to:
olApp.WindowState = xlMinimized
I've tried:
Set olApp = CreateObject("Outlook.Application")
followed later with code to send emails,
Set objol = New Outlook.Application
Set objmail = objol.createitem(olmailitem)
With objmail
.To = EMTo
.cc = EMCC
.Subject = EMSubject
.Body = EMBody
.NoAging = True
.Attachments.Add EMFile
.Send
End With
But I get an error "You don't have appropriate permission to perform this operation" referring to:
Set objmail = objol.createitem(olmailitem)
Because of the way our network is designed, the only code that works to send emails is:
Application.ActivateMicrosoftApp (xlMicrosoftMail)
Set objol = New Outlook.Application
Set objmail = objol.createitem(olmailitem)
With objmail
.To = EMTo
.cc = EMCC
.Subject = EMSubject
.Body = EMBody
.NoAging = True
.Attachments.Add EMFile
.Send
End With
but Outlook remains open the whole time the emails are being sent until it's closed by code later on.
Is there a way to minimize outlook AND use the code above?
View 9 Replies
View Related
Jul 21, 2014
link a date within a Excel sheet to the Calander in Outlook so a reminder can be triggered on said date.
View 2 Replies
View Related
Jun 26, 2014
Below I have my code that works great. What I would like to do is make it pull the .HTMLBody from a cell value instead of inbeded in the code so users can change, just like to I have it below for who I am sending it to. The issue is if I do it the same way I loose my signature and the font, size and color I have below. How can I do this.
range("P16") would be the 1st line of the mesage
range("P17") would be the 2nd line of the mesage
range("P18") would be the 3rd line of the mesage
All the sendkeys below copy a range and paste it below my message as a picture currently. That is fine.
[Code] .....
View 1 Replies
View Related
