Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Mailing List Data Manipulation - excel
Sign in to Add to Watch List

Admin Support > Mailing List Development

View Change History

The client has made the following changes to the job.


Job awarded.

Jun 20, 2012

Job Description

  |  Change History >>


  • Posted: Wed, Jun 20, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I want to send out letters to aircraft owners in Australia. The excel spreadsheet
details all the owners but it is not easily merged with Word for easy printing of letters and envelopes.

So the job is to modify the spreadsheet so that I can easily merge the data and print letters and envelopes.

To do this, you will need to:

1. open the attached spreadsheet.

2. remove all duplicate entries.

3. remove all entries where the registered holder (In column M) (regnholdname) is not natural persons. ie flying clubs, pty ltd companys, ambulance, air force, etc

4. remove all entries where the registered operator (In column U) (regopname) is not natural persons. ie flying clubs, pty ltd companys, ambulance, air force, etc

5. eliminate all duplicate entries ... (I only want 1 letter going to each address)

6. The person's name that we will be mailing to (in column M or U) is in the format of SMITH, Fred. That looks bad when you merge it to print on an envelope, so I need SMITH, Fred c...

Sign in or Register to see more

Job ID: 31364678
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Lal Sivadasan      
Lal Sivadasan's identity has been verified.  Learn More
 Bahrain  |  
"Bolssra BPO Solutions" Experienced and enthusiastic freelancers (Team of 10 Data Entry Operators) here to work for you. Expertise includes Data...
 5.0   |  Private   |  29 Jobs
Bid ID: 31369623  |  Submitted: Jun 20, 2012 11:07 ET 
Within 1 day
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »