View Single Post
 
Old 09-28-2011, 01:22 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Follow these steps in order. I use Office 2010 but these steps are from Office 2007:
1. Open MS Word.
2. Click on the Mailings Tab.
3. Click on Select Recipients Button.
4. Click on Use Existing List.
5. Open the folder containing your client data and click on the file name.
6. Click on Open.
7. Click on the Sheet Name that contains your client data.
8. Click OK.
9. Click on Insert Merge Field and select each merge field you wish to insert into your mailmerge document.
10. Click on Start Mail Merge button.
11. Select Step by Step Mail Merge Wizard.
12. Click the Letters Radio button.
13. Click on the "Next: Starting Document" hyperlink.
14. Click the Use the current document" radio button.
15. Click on the "Next: Select recipients" hyperlink.
16. Click on the "Use existing list" hyperlink.
17. Click on the "Browse" hyperlink button and navigate to your client data spreadsheet and click on the filename.
18. Select the worksheet containing your client data.
19. Click OK.
20. You will then be presented with the list of records. You will now be able to de-select those records you dont wish to Merge if required.
21. Click OK.
22. Click on the "Next: Write your letter" hyperlink.
23. Click on "Next: Review your letter" hyperlink.
24. The first record will be merged.
25. To complete the mailmerge process simply click on the "Next: Complete the merge" hyperlink.
These are all the steps you should need to use. You should not have to select any DDE options.
Good luck and let me know how you get on.
Tony(OTPM)
Reply With Quote