linkjg

I'd rather not have to take this into Excel and shorten the characters there. But, thanks for your suggestion. I'm looking for something I can do within Word.

I'm using Microsoft Word 2002. I've been doing mail merges for almost a year now, with no problems. My database is an Excel worksheet. Today when I clicked on "select recipients" and selected my Excel worksheet, I have this "Data Link Properties" box pop up. This is the first time I've seen this, and after rebooting, the dialogue box is still there. I've been trying to research how to turn this feature off, if it can be turned off. The "Data Link Properties" box is asking for an Access database, which I do not have. I click cancel, but I can't get to my Excel list anymore to select the rows for the merge. Can anyone explain how I can get rid of this and start doing mail merges again! I'm attaching a screenshot of the dialogue box.

I have a task that I'm doing daily, and I thought that maybe a macro could help speed things up. On a Word document after the words "Skill:" I have to shorten the characters after the last colon by 7 characters Is there a fast way to do this with a macro? How could I do that? Thanks!