The main document contains the text and graphics that are the same for each version of the merged document. The active document becomes the main document. Under Select document type, click Letters. In Microsoft Office Word 2007, click Start Mail Merge in the Start Mail Merge group on the Mailings tab, and then click Step by Step by Mail Merge Wizard. In Microsoft Office Word 2003 and in earlier versions of Word, point to Letters and Mailings on the Tools menu, and then click Mail Merge Wizard.
#Mail merge word mac not working how to#
For example, in a mailing list, each row might include information about a particular recipient.Ĭreate your Excel data file, and then arrange it by using the fields that you want to use for your letter, as shown in the following sample data file.Īfter you create your Excel data file, save it, and then close the data file.įor more information about how to create a mail-merge address list, click the following article number to view the article in the Microsoft Knowledge Base:Ģ94688 How to design and set up a mail merge address list in Word 2002 and in later versions of Word The first row should contain field names for each column - for example, Title, Salutation, First Name, Middle Name, Last Name, Address1, and Address2.Įach row should provide information about a particular item.
Note the following requirements for the data table: The text in an output document can be the same in all output documents, but you can apply formatting to specific documents.īefore you proceed with the Mail Merge Wizard, make sure that your Excel worksheet is well structured for this purpose. The output documents are the result of the mail merge.
This database is typically a list of names, addresses, phone numbers, and other categories of personal information. For example, the recipient list is a Microsoft Access database file or an Excel worksheet. The recipient list is a database that contains the data that is to be merged into the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another. The main document contains the basic text that is the same in all of the output documents. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. I realise that I could generate the data source into a new workbook and then close it before running the merge, but that is an inelegant solution.Īny guidance on the appropriate method and syntax would be much appreciated.How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet The wrong one, but I cannot find an alternative method that tells Word that its data source is already open. I guess that the OpenDataSource method is If I accept that I can proceed, but clearly that is not an acceptable answer. SQLStatement:="SELECT * FROM `'XFERDATA'`", SQLStatement1:=""Īt the problem point I get a box telling me that I cannot open the data source, but offering me a read only copy. Name:=ThisWorkbook.Path & "\DailySheets.xlsm", _ Set objMergeDoc = (ThisWorkbook.Path & "\ctPURCHASE ORDER.dotm") Set objDocument = GetObject(, ObjWord.Document) Set ObjWord = CreateObject("Word.Application") Set ObjWord = GetObject(, "Word.Application") \ctPURCHASE ORDER.dotm is the Mail Merge document.
#Mail merge word mac not working code#
In the code below, XFERDATA is the named range within one of the worksheets in the excel workbook where the code is located. Suitable syntax to tell word to use the data source that is already open. My problem lies in that when the code gets to the point when it defines the data source for the merge, it tries to open it, but finds that it is already open (because that is where the code is running from!) Extensive research has not found a The code for the mail merge primarily by recording a macro in Word and then adapting it to run on excel.
I cannot therefore set the references to Word because it is different for each machine.
I am using late binding becauseĮxcel and word have to run on machines that use different versions of Office (20), but all have to save back to the Office 2013 machine. The data is located in a named range within one worksheet of the open workbook. I have an Excel workbook using VBA to prepare data for a mail merge to word and then to run the merge from within the Excel procedure.
0 kommentar(er)
