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" Experienced and enthusiastic freelancers (Team of 10 Data Entry Operators) here to work for you. Expertise includes Data...
8
  |  
 4.9   |  Private   |  43 Jobs
Bid ID: 31369623  |  Submitted: Jun 20, 2012 11:07 ET 
Delivery
Within 1 day
$30.00
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »