Mail Merge - Word v Access v Excel

  navvyman 16:26 29 Nov 2005

I have the data stored as a Word table, An Access table and an Excel sheet. The merge works perfectly except that using Excel as the source the Mail Merge Recipients box does not show all the fields. If I add new field as the rightmost column it does not appear in the dialog box. If I rearrange the columns it does. I am mystified

Does anyone have any clues as to why Word should see the 3 datafiles differently

Running Win XP Pro and Office XP

  Taff™ 09:41 30 Nov 2005

It`s to do with the way Word exchanges the data with the different applications. See click here for an explanation of why, for example, dates don`t convert in the same format from Excel. If you read down and "confirm the file conversion" in Word you will get alternative methods of data exchange.

In your case, when you link to the file initially via Word it looks at the range of columns say from A-P and these are the limits. Add a column Q and it is outside the initial range, move it before column P and it is within the range because it already has a link to column P. The short answer is to add the additional columns, save the file and close it. Close word and open it again and it should then recognise the new column immediately.

  navvyman 13:30 30 Nov 2005

Many thanks Taff - concise and coherent and now all works a treat.

Converting files like billy-o!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?