PROBLEMS WITH WORD MAIL MERGE FROM EXCEL HOW TO
If you know of any way to find out what source a particular mail merge is using, or how to find the stored file path for the data source, I’d appreciate it if you could add that information to the comments below. All the Mailings tab options are now available to you. Select the worksheet in the Excel file when asked (in my client’s case, it’s the well-named ‘Sheet 1’!).Navigate to and select the Excel spreadsheet (or other data source if you’re not using Excel), then click Open.Mailings tab > Select Recipients > Use Existing List.I figured out a quick fix to reattach the data source to a Word 2007 mail merge letter template: Sometimes the mail merge works other times they just get grayed out options on the Mailings tab in Word 2007 (likely the same in Word 2010).
I’ve been setting up the letter template and the data source on my computer and then emailing the files to my colleagues, who’ve then dropped the files onto a network drive or into a local folder. I suspect it’s because Word is storing the file path to the data source somewhere that we can’t see or find. I have made sure all the format is the same. All our system has default language as English UK The Excel file has dates as dd mm yyyy When adding to the word doc the date is transferred as US ie mm dd yyyy.
Prior to 365 I have not had any problems but i now do have a problem. A few times my colleagues and I have experienced the situation where a mail merge template lose its connection to its data source (in my client’s case, an Excel spreadsheet). Mail Merge - Excel to Microsoft word not working correctly Hi, I have created a mail merge with a few hundred rows of data in excel to populate into Microsoft word, however for some of the records is not populating all of the text. I use an excel file to store data and merge this data to a Word doc.
0 kommentar(er)
