How can I merge from Microsoft Excel to a generic Microsoft Word letter?
Friday, August 21st, 2009 at
6:01 am
I have a data base of thousands in excel and I have a generic letter on Microsoft Word. I would like to select candidates from Excel and copy their names and address into the letter for a direct mail campaign. Any help or were to find the instructions will be appreciated
Related posts:
- How can I merge my excel file to microsoft access? I have data in excel that I now want in...
- How do I remove Duplicate rows with same first column, but different other columns in Microsoft Excel? I have date I am trying to consolidate in Microsoft...
- How do I copy and paste rows with a certain value from one worksheet to another in Microsoft Excel? I am trying to create a macro in Microsoft Excel....
- How do I change the format on my Microsoft Word to formal letter format? I have to type a formal letter for Honors English...
- What are the best sites that give tutorials on how to use microsoft Word and Excel? I’ve a job interview tomorrow, and I need to know...
Filed under: Microsoft
Like this post? Subscribe to my RSS feed and get loads more!
Mail merge function in Word will do that for you. First you must separate out your “select candidates” into a separate file for sheet.
In Word > Tools > Letter and Mailing > Mail Merge Wizard
on the right hand side panel, Select the type (letters), and next
Pick the letter here, next
Click browse to find the excel file for the recipients
Following the remaining prompts and done.
Once merge, you will need to click the “view Merge data” to see the actual print. Otherwise, all you see is the first letter