Mail merge from Excel

[sarah_03uk]

Hi, I am creating a letter in Word and using Excel as a data source for the mail merge.

I know how to merge from Excel into Word but not how to merge data from different sheets within the Excel workbook?...It only seems to merge the first sheet.

Is this possible to merge data from each sheet either altogether or individually and if so how do I do it?? Thanks x

[wideboy]

This might be a start (from Googling):-

Use the Worksheet converter

http://www.computorcompanion.com/LPMArticle.asp?ID=64

[Hammer Head]

I know this may not solve your problem, but I think it is easier to mail merge from Access if you have it. I realise that this may mean transfering a lot of data but it puts all the data in one place. I also find that Access is much more useful if you want to manipulate the data in any way.

[sarah_03uk]

Yeah I agree Access is much better, but this is something im doing at work and Access is not installed . I suppose I could just copy all the data from sheet 2 lets say and paste it into the 1st sheet then merge it, but I just wondered whether you have an option of which sheet to merge from, as it is simpler to keep the data we have in separate sheets rather than separate documents.

Thanks though! x

[Gandy]

Hi Sarah, You need to create a named range that spans the worksheets. Your mailmerge will then need to refer to this range. It's pretty straightforward but it did take me some time to work out the first time. Let me know if you need more help