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.
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:
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
|Tags: city, email address, program, state, zip code|
|Thread Tools||Search this Thread|
|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|