![]() ![]() (the second of these uses a macro to apply some additional formatting). The spaces represented in the field constructions are all required.įor some working examples of this approach, see: Nor is it practical to add them via any of the standard Word dialogues. ') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac) you can't simply type them or copy & paste them from here. ![]() In that case, you could use a DATABASE field coded as: Let's also assume the mailmerge main document is kept in the same folder as the data source. a separate Excel Worksheet or Access tbale) that has fields for employees' Firstname, Surname, Employee ID, & Job Title, and that against each record is recorded their Manager's ID. ![]() Manager IDs) and any other fields that occur once per group, and a separate data set (e.g. Suppose you have a relational database or, an Excel workbook with a separate table listing each of the grouping criteria (e.g. Note 1: Please read the tutorial before trying to use the mailmerge main document for a mailmerge - the merge field coding you'll need is in the tutorial and has to be copied from there into the mailmerge main document before you can do a mailmerge.Īlternative Approach: Using DATABASE fields to Create Lists Sorted by CategoryĪnother option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. to merge to emailPlus, unlike the field coding suggested by the MSKB articles, my approach doesn't insert extra lines for Excel data sources.to shade alternate rows when merging to a table.to create a series of tables from the merged data.group and sub-group counts and totals can be calculated without the need for such fields in the source data.text can be added after the repeated data.Use mail merge for bulk email, letters, labels, and envelopes - Office Supportīut my tutorial goes way beyond those articles' scope by:Ī ) providing a sample data source that can be used to demonstrate/test the use of different keys, HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000 Attached to the bottom of this post is a tutorial on how to use Word's mailmerge facility to create lists sorted by category. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |