mail merge 1

[angler2229]

I am teaching our faculty to mail merge using Excel and Word. Everyone does fine until they get to the Get Data Source. The Open dialog box default is set to Word documents.

My question is, Why isn't Excel the default? It's the Excel files we are trying to locate. Is it because we are in Word? I can accept that. It would be nicer if the Excel documents choice was closer to the top of the list instead of at the bottom where one has to scroll. I guess I am venting!

Maybe I am missing some secret.

Daniel

 

[MMSantiago]

I'm pretty sure you are correct about the default setting. Most of those dropdowns, however, will accept keyboard input. That means that you might be able to get to the Excel listing by clicking in that field and typing "E". It worked for me in Word XP. Hope this helps a little.

 

[angler2229]

MMSantiago,

I will have to try that. Thanks!

daniel

 

[SkipVought]

Hi,

Word is the default 'cuz most Word users have their data in Word Tables rather than Excel. Now I prefer Excel, myself, for a data source, so I have to do the same thing -- scroll down for that .xls

Oh, well!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[angler2229]

Thanks, Skip. Next class I can show them both ways to save data sources. Usually I just select one way so as not to confuse them with too much info. But this one may be worth while!

Thanks,

Daniel