| Project Name |
Handwritten Envelopes Project |
| Project Description |
This project is related to the real estate industry of US, which is an ongoing project on weekly basis or as per client's requirement. Client provides us an excel sheet containing different property addresses, relevant website URLs and a word file containing the format of letter through e-mail or FTP Transfer. We need the following information to be collected from particular website for each property:
 Owner name
- Owner's City, State, Zip code
- Owner's address
All the information is to be collected from the website and enter into the same excel sheet for the purpose of mail merge into the word format. After completion of mail merge, we have to take print of all the letters, Handwrite the addresses on the blank envelopes, put the letters in appropriate envelope, sort the envelopes by phone numbers as well as zip codes and ship them to client for further distribution in US. |
| Input Data |
Excel Spreadsheet containing property addresses and MSWord Document of master letter |
| Output Data |
Hard copies of letters, delivered through courier/post. |
| Volume of Work |
Approx. 50K Letters a month |
| Type of Project |
Personalized Mailing |
| Turn Around Time |
We turn around approx. 2K letters a day |
| Tools used |
MS Excel, MS Word, I Opus, and I Explorer |
| Challenges faced |
There were no specific challenges faced
|
| Project Name |
Handwritten mails |
| Project Description |
This project is related to the real estate industry of US, which was a onetime project. The client provided us an excel sheet containing different property addresses and owner names along with a Master word file containing the format of letter through e-mail. We required merging the Excel data into the MSWord document using the Mail Merge utility, print the letters, handwrite the mailing and return addresses on the blank envelopes, stuff the relevant letter into the envelopes and send the ready posts to the client for further distribution in US. |
| Input Data |
Excel Spreadsheet containing property addresses and MSWord Document of master letter |
| Output Data |
Hard copies of letters, delivered through courier/post. |
| Volume of Work |
500 Letters |
| Type of Project |
Personalized Mailing |
| Turn Around Time |
We've turned around the 500 letters in 2 days only |
| Tools used |
MS Excel and MS Word |
| Challenges faced |
There were no specific challenges faced |
