Ok so i've now gone into my word template and done the following:



Word Office button>Word Options>Advanced>General and checked the "Confirm file format conversion on open" box. Clicked ok, re-saved the doc and exited.

I then re-open said template and go to mailings>select recips>use existing list and select the relevant workbook. It then brings up the Confirm Data Source box. I check the "show all" field at the bottom and hit ok. I'm then lead to believe I should be using the "MS Excel Worksheet via DDE" option? However, when I do I don't seem to be able to extract the data from the specific worksheet I require.

Getting there slowly but could perhaps do with a hand on this last but if anyone's got a suggestion?

Hi
I am using Office 2010. However I do not get the option of using MS Excel DDE. Are you able to bypass that option. I have tested it in 2010 and there is no option to use DDE and it works fine for me.
If this is still an issue can you post a screenshot that shows the DDE option for me to look at.
Good luck.
Tony(OTPM)

Hopefully i've attached it to this msg....

Attached Images

MS.jpg (46.2 KB, 20 views)

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)