Hi People, its many years since I did a mail merge. However I have often wondered, is it possible to pull data from various cells of a spread sheet and have that data appear on a word doc without having to line up columns and rows as you would in a mail merge spreadsheet?

Any ideas.



Ideally I would like to print 12 docs and have the data on each doc from various cells in the same spreadsheet?

Has Microsoft come that far?

Thanks
James

Hi
You can use an Excel document as a mail-merge source document. However you seem to be indicating that you want to use particular cells in Excel as your source data. If this is the case and it will always be the same cells you could paste a link in your Word document to those cells. For example right click in your first cell in your worksheet and select copy, then move to your Word document and right click at the position you want to paste and select Paste Special followed by Paste Link.
Hope this helps.
Tony