A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

MM won't open Excel sheet



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2007, 08:17 PM posted to microsoft.public.word.mailmerge.fields
kbtoreador
external usenet poster
 
Posts: 2
Default MM won't open Excel sheet

I've used MM quite a bit, but for some reason, as I'm trying to create
labels, it stops after allowing be to selcet my recipient list and does not
give me the next window. Instead, it gives me a 'Select Table' Menu, only
there isn't anything to select. Usually it goes right on through so I can
complete the steps, but I can figure out what is wrong with my Excel document
where it won't allow me to complete this mail merge. Any ides?
  #2  
Old October 9th, 2007, 11:12 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default MM won't open Excel sheet

Which version of Word/Excel?

If the "bad" workbook is simple enough (e.g. no formulas, just data, try
exporting the sheet(s) to .csv format and importing them into a completely
new workbook.

Does the Select Table menu have an options button where you can check 4
boxes, and if you do, do you then see any tables? Are they the ones you
expect? Can you connect to them?

Have you done anything like use the data menu to make a list or a database
in your workbook?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"kbtoreador" wrote in message
...
I've used MM quite a bit, but for some reason, as I'm trying to create
labels, it stops after allowing be to selcet my recipient list and does
not
give me the next window. Instead, it gives me a 'Select Table' Menu, only
there isn't anything to select. Usually it goes right on through so I can
complete the steps, but I can figure out what is wrong with my Excel
document
where it won't allow me to complete this mail merge. Any ides?


  #3  
Old October 10th, 2007, 07:40 PM posted to microsoft.public.word.mailmerge.fields
kbtoreador
external usenet poster
 
Posts: 2
Default MM won't open Excel sheet

I put it in a new document, and it seems to be working.

"Peter Jamieson" wrote:

Which version of Word/Excel?

If the "bad" workbook is simple enough (e.g. no formulas, just data, try
exporting the sheet(s) to .csv format and importing them into a completely
new workbook.

Does the Select Table menu have an options button where you can check 4
boxes, and if you do, do you then see any tables? Are they the ones you
expect? Can you connect to them?

Have you done anything like use the data menu to make a list or a database
in your workbook?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"kbtoreador" wrote in message
...
I've used MM quite a bit, but for some reason, as I'm trying to create
labels, it stops after allowing be to selcet my recipient list and does
not
give me the next window. Instead, it gives me a 'Select Table' Menu, only
there isn't anything to select. Usually it goes right on through so I can
complete the steps, but I can figure out what is wrong with my Excel
document
where it won't allow me to complete this mail merge. Any ides?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.