176985602337900

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.

Description
Date

Job awarded.

Jun 20, 2012
Close

Job Description

  |  Change History >>

Updated

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

    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
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Bahrain  |  
Winner
Bolssra BPO Solutions is one of the reliable offshore BPO providers on Elance. Our expertise includes Data Entry, Web research, Data Conversion,...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 31369623  |  Submitted: Jun 20, 2012 11:07 ET 
Delivery
Within 1 day
$30.00
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 »