Ok here are the docs with some details filled in
download
Code:
http://www.mediafire.com/?o4yvu3zij4vzu6r
VT
Code:
https://www.virustotal.com/file/ddef16079f313333e0e0d87f2dbc1f4987f48bf722ec883ae5797d18bdf303a0/analysis/1329102992/
And, here is the whole process (from memory).
Firstly find all of the clients you want to send to and fill in their details in the spreadsheet called "
Customer Details.xlsx"
Next, go to google keyword tool and do your keyword research. Have a look at the
keyword oxon file to see how I copied, cropped and pasted this together. You should only need to do this once per batch (see below).
I also download the keyword results and pasted them into the "
Customer Details.xlsx" file on the right. This makes it quicker to get a rough estimate of the number of searches.
Next I did a quick search in google using one of the keywords and created a screenshot of this, see the example
search oxon to see what I mean, again you should only need one copy of this saved.
Then...
Open the Word doc "
mergeplacementletter.docx" into Word. If it asks if you want to run the SQL command say yes and if necessary choose "
Customer Details.xlsx".
If it doesn't link itself to the excel file choose
Mailings -->
Start Mail Merge -->
Letters then choose
Select Recipients -->
Existing List --> and choose the "
Customer Details.xlsx" file.
If you use something like Yellow Pages to gather your leads you can easily find 15 to 20 leads in the same category i.e. Accountants. That way you will only need one copy of the "
keywords" and "
search" documents since each customer will be sent the same thing.
I hope this helps but I can see that my explanation is not the greatest and there is room for misinterpretation so if you need any clarification then please just ask.
OP, I am really sorry if this hijacks your thread I am just really keen that people try this out for themself and to this end I am just trying to make the process as simple as possible.
Hope this helps...