Mail Merge Headings

[Mix.G]

I am trying to merge information from a reguarly used excel document.
the merge it self is ok, the problem is that the colomn headings are coming
up as F1, F2 ect. in the merge. the headings I need are two rows down in the
document (Name, Address, etc.). I can not change the excel document.
How do I get mail merge to recognise the 3rd row as the headings?

 

[Peter Jamieson]

One way is to select the area of the worksheet that you want to use as
the data source and define a range name for that area. Then go through
the connection process again and choose that range name rather than the
worksheet name. However, you will probably find that you need to adjust
the area that the range name references manually as you add/remove rows
in the worksheet.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

 

[Mix.G]

Fantastic! It worked beautifuly. Your a legend... Thanks for the help.
Have a great day =)