> > I need to mail merge two letters from two different worksheets in Excel but > > even when I name the ranges, Word does not give me the option to use the data > > in my mail merge.
I'm not a mail merge expert, but I think you should be able to use Word 2000 with an Excel XLS file (but maybe not with the newer XLSX file type). In addition to the Microsoft instructions available from a Google search, I suggest Note that you can use a Word table as the data source.
And, if you want to use Excel as the data source, you could post again here or in the Word forum, and explain how you know that 'Word does not recognize my Excel 2010 format.' The response to my action in identifying the source or the data to be used in the label function of Word was that the file format/file type of Excel could not use Excel 2010 file type 9.0; that it could only work with Excel file types 3.0,4.0,5.0,7.0 or 8.0. Is their a patch for Word 2010 to accommodate Excel 2010; type 9.0? Your earlier messages said you are using Word version 9, aka Word 2000.
Your most recent message asks about Word 2010 (version 14). Word 2010 does not require a patch to work with Excel 2010. If you are trying to use Word 2000 for a mail merge with data from Excel 2010, have you tried to use the Save As command in Excel 2010 by specifying the 'Save as type' option named 'Microsoft Excel 5.0/95 Workbook (.xls)'?
How to Automate Mail Merge through VBA in Microsoft Excel In this article, we are going to learn how to automate the mail merge by using the VBA in Microsoft Excel. Mail Merge: – This is the source to merge the data’s information into text and then print the document. To perform such operation, we use Microsoft Word. Let’s understand with a simple exercise:- We have a letter format in Report sheet, and we want to apply mail merge through VBA in which we want to change the letter details as well. We have 2 sheets. 1 sheet contains data with details to whom we want to give letters.
In first data, column A contains Name, column B contains street address, column C contains city, column D region, and column E and column F contain postal zip. There is one command button to move in the report sheet. 2 nd sheet is having the letter format with 2 command buttons; one button to move on the data sheet and second command button is to work for mail merge Firstly, we will write the VBA code for command button of Main Data. We need to follow below given steps:-. First we will insert command button in the worksheet. Go to Developer tab and then insert Command button from Activexcontrol. Rename the Command button with the name “Letter”, and now assign below mentioned macro.