Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Most efficient program for finding out associated email address

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 03-03-2011
Member
 
Join Date: Mar 2011
Posts: 1
Most efficient program for finding out associated email address
  

The company that I work with recently purchased a list of company names, addresses, city, state, zip, and phone numbers of potentially interested clients for our services. I have an excel spreadsheet that looks like this:



And I am responsible for finding the associated email address for that clinic.
This seems like a simple task, but I have 33,000 of them to find in one week. If anyone knows the simplest way to go about this, whether it is a program or a macro I could make, I would greatly appreciate any help.

Reply With Quote
  #2  
Old 04-03-2011
Member
 
Join Date: Dec 2007
Posts: 994
Re: Most efficient program for finding out associated email address

You could try to copy and paste the following codes that is given below in the macro window (alt F11) for finding out email address and check whether it works out for you or not:

Code:
Sub query()
x = Cells(Rows.Count, 1).End(xlUp).Row
For a = 1 To x
Cells(a, 3) = "www.website.com/searchabc123etc=" & Cells(a, 1) & "+" & Cells(a, 2)
Next a
End Sub
After that, you just need to run the macro and it will make custom URL's. Hope that helps.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Most efficient program for finding out associated email address"
Thread Thread Starter Forum Replies Last Post
Mail setting to show email address with sender name in Outlook 2010 and Calendar to decline attendance wihout deleting program invitation in Microsoft Office 2010 . Padmasola Windows Software 3 04-12-2011 08:20 AM
Finding the IP address of another host in the network Benjhonson Networking & Security 5 03-12-2010 07:47 AM
Tomtom XL not finding the correct address richiepask Portable Devices 7 16-08-2010 05:07 PM
Finding The IP Address In Gmail Rohit Kasle (RK) Tips & Tweaks 1 05-02-2010 04:32 PM
Finding IP address GaryK Technology & Internet 2 10-10-2008 06:54 PM


All times are GMT +5.5. The time now is 02:00 PM.