Solved: Mial Merge

[elkrott]

I am running home XP. I have a table of addresses in Word 97/2000 xxxxxx.doc. When I select Mail Merge, Options, Get Data, Open Data Source it just goes back to Mail Merge Helper menu. I get no error message. I have an older file that works OK but my latest updated doc file does't work.

 

[Anne Troy]

Select and copy only the cells that contain data into a new workbook, and paste it as values only. You may have to do a little bit of reformatting.

Oh...make sure freeze panes isn't on in the Excel file. Though I don't think it's supposed to affect it, I think it has before for me.

 

[elkrott]

Thanks, But I found my problem. Doc was set as a Mail Merge Doc.
I had to set up a keystroke for the command Reset Mail Merge Doc to Normal doc.
Thanks again.
Ellis