mexicanpizza
01-28-2008, 11:59 PM
************************************************** ******
Detailed walk-through for excel newbies in post #72, here: http://www.ronpaulforums.com/showthread.php?p=1117819#post1117819
************************************************** ******
Hey there....thought I would document what my wife and I decided to do in our precinct. We are both shy and very busy so canvassing has been hard to get time/nerve (but we're still going to try! ;) )
We decided to send out a personal letter to every Republican in our precinct. It's fairly simple to move the precinct addresses into a useful, automatable format...in my case I imported everything into Excel and filtered for Republicans and duplicates in the same household with the same last name. This amounted to ~450 voters in ~348 households.
Then we wrote and printed our personal letter, and put a candidate comparison and some RP quotes on the back. We addressed all of them using Word and a mail merge using Excel as the data source. Printing 350 double sided letters took less than an hour using our $99 laser printer.
Here is our precinct mapped using http://batchgeocode.com (AWESOME site for mapping addresses en masse):
http://scaryknife.com/images/ronpaul/precinctmap.jpg
Stack of letters...you can get an idea of the candidate comparison:
http://scaryknife.com/images/ronpaul/rp%20%281%29.JPG
Stick in a slim jim:
http://scaryknife.com/images/ronpaul/rp%20%282%29.JPG
Sit and fold/stuff for ~2 hours:
http://scaryknife.com/images/ronpaul/rp%20%283%29.JPG
The finished product:
http://scaryknife.com/images/ronpaul/rp%20%286%29.JPG
Total breakdown:
Joining voters.ronpaul2008.com $0
Download precinct voter info $0
Reformat in excel, filter Republicans $0
Map people @ batchgeocode.com $0
Ream of 24# bright white laser paper $7.99
Box of 500 windowed envelopes $18.99
Print 350 double sided b&w flyers $ ?? (cheap on home laser)
350 Slim Jims free from meetup
2 hours folding/stuffing with wife $0
Postage (350*0.41) $143
Total cost $170
Homes/voters reached: 350 / ~440
Our letter is hosted here (WORD DOC (http://scaryknife.com/images/ronpaul/RP-Mailing.doc)), and (PDF (http://scaryknife.com/images/ronpaul/RP-Mailing.pdf))
Get out there people. After I send these, I'm calling as many as I can this weekend.
If anyone needs help with list formatting/filtering, let me know!
************************************************** ******
Detailed walk-through for excel newbies in post #72, here: http://www.ronpaulforums.com/showthread.php?p=1117819#post1117819
************************************************** ******
Detailed walk-through for excel newbies in post #72, here: http://www.ronpaulforums.com/showthread.php?p=1117819#post1117819
************************************************** ******
Hey there....thought I would document what my wife and I decided to do in our precinct. We are both shy and very busy so canvassing has been hard to get time/nerve (but we're still going to try! ;) )
We decided to send out a personal letter to every Republican in our precinct. It's fairly simple to move the precinct addresses into a useful, automatable format...in my case I imported everything into Excel and filtered for Republicans and duplicates in the same household with the same last name. This amounted to ~450 voters in ~348 households.
Then we wrote and printed our personal letter, and put a candidate comparison and some RP quotes on the back. We addressed all of them using Word and a mail merge using Excel as the data source. Printing 350 double sided letters took less than an hour using our $99 laser printer.
Here is our precinct mapped using http://batchgeocode.com (AWESOME site for mapping addresses en masse):
http://scaryknife.com/images/ronpaul/precinctmap.jpg
Stack of letters...you can get an idea of the candidate comparison:
http://scaryknife.com/images/ronpaul/rp%20%281%29.JPG
Stick in a slim jim:
http://scaryknife.com/images/ronpaul/rp%20%282%29.JPG
Sit and fold/stuff for ~2 hours:
http://scaryknife.com/images/ronpaul/rp%20%283%29.JPG
The finished product:
http://scaryknife.com/images/ronpaul/rp%20%286%29.JPG
Total breakdown:
Joining voters.ronpaul2008.com $0
Download precinct voter info $0
Reformat in excel, filter Republicans $0
Map people @ batchgeocode.com $0
Ream of 24# bright white laser paper $7.99
Box of 500 windowed envelopes $18.99
Print 350 double sided b&w flyers $ ?? (cheap on home laser)
350 Slim Jims free from meetup
2 hours folding/stuffing with wife $0
Postage (350*0.41) $143
Total cost $170
Homes/voters reached: 350 / ~440
Our letter is hosted here (WORD DOC (http://scaryknife.com/images/ronpaul/RP-Mailing.doc)), and (PDF (http://scaryknife.com/images/ronpaul/RP-Mailing.pdf))
Get out there people. After I send these, I'm calling as many as I can this weekend.
If anyone needs help with list formatting/filtering, let me know!
************************************************** ******
Detailed walk-through for excel newbies in post #72, here: http://www.ronpaulforums.com/showthread.php?p=1117819#post1117819
************************************************** ******