Microsoft word confirm data source

Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Continue with your letter , email message , label, or envelope merge. Tip: You can prevent being prompted by Word every time you open a data file.

Under General , clear the Confirm file format conversion on open check box. If you've built a contact list in an Excel spreadsheet, it's important to format any zip codes or postal codes as text to avoid losing data.

If you're importing into a new spreadsheet any contacts from either a text. If you're already using an Excel spreadsheet as your data source for a mail merge in Word, go to Step 2 in this topic. In Delimiters , check the box that matches the delimiter that separates each element of your data such as a tab or comma.

Then choose Next. Tip: The Preview of selected data pane shows you what the results will look like in a table format. In Preview of selected data , choose the column that containing the zip codes or postal codes. Then, in C olumn data format , choose Text. Repeat step 5 as necessary, choosing the column you want to change and the data format you want to apply. Note: Each time you apply a data format to a column, the name of the format appears in the table header for that column.

To ensure your zip code or postal code pass through a mail merge without losing any zeros, format the column containing those codes as text. On the Home tab, in the Format box, choose Text. Now, you can use this data for a mail merge. Step 1: Set up your data source in Excel If you're using an Excel spreadsheet as your data source for a mail merge in Word, skip this step.

After you successfully import a. Open Excel. Choose the. In the preview window, select Transform Data. Select Replace current. Repeat steps 5 - 7 as needed. Liese Windows 7 64bit Office 64bit. I'm having the same type of problem. But in my case, I was using Windows XP OS, and had created a Word template that consists of a table with merge fields in it, saved to the Microsoft Template directory as a.

It worked just fine. Our company switched our computers to Windows 7 64 bit and Word Then I browsed to the new data lodation and it merged fine. I save template file. But it seems no matter what I try, my Word Template never retains the data source, and I have to keep on attaching it every single time I want to merge data from that file name. I have tried changing the location of the files, changing the Trust settings in Word, tried doing them in dot format, in dotx format, etc. I've tried creating a new dotx file and even a docx, and copy and pated the table into it and then tried to merge to that.

I tried so many variables that my head is spinning. Right now the template is saved to the microsoft template file folder via "users". I've run out of ideas.

Is this a bug? Help please Hi Liese, A couple of points: 1. Mailmerge main documents really shouldn't be saved as templates - they're intended to be used as documents.

Quite long but more robust! I moved all my files to a new computer, resulting in a new data path for the Excel file the Word mail merge doc is linking to. I too found that changing the data source in that pop up window did not save. Running Word , I accidentally thankfully! And that's it. I saved it and it opened correctly the next time I needed it. No more error The answer by traveltcg works well except that it does not retain the filter and sort options from the original doc file.

It's still the easiest way, assuming you can recreate the filter and sorts. Office Office Exchange Server. Not an IT pro? Resources for IT Professionals. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.

Word IT Pro Discussions. This forum is for general questions and feedback related to Word all versions as they pertain to the IT Pro community. Sign in to vote. I have a mail merge document which was migrated to a new server.

Now every time when I run the mail merge document it tells me "Error has occurred: The Microsoft Access database could not find the object ' '.

Make sure the object exists and that you spell its name and the p". In the error it points to the old path on the server. When I click OK the data link properties window pops up.