Manipulation

Labels: Formatting, Merge

Not just MailMerge anymore

Labels: Addin, Macros, Merge, Tips, VBA

Database integration

"You can merge Microsoft Office Access 2007 data with a Word 2007 document by using the Mail Merge Wizard. This demo shows you how to create a simple form letter and how to troubleshoot problems. You can also use this feature to create address labels or any other type of Word document in which you want to display Access data."

Labels: Merge, Tutorials

Merge Ahead!

Opening this will run the following SQL command:

SELECT * FROM C:\file_name.log

Data from your database will be placed in the document. Do you want to continue?

1. Open Registry Editor.
2. Locate, and then click the following registry key:
   
   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
   
   (Use 12.0 for Word 2007)
   
   
3. Click Edit, point to New, and then click DWORD Value.
   
   
4. Under Name, type:
   
   SQLSecurityCheck
   
   
5. Double-click SQLSecurityCheck.
   
   
6. In the Value data box, type:
   
   00000000

Labels: Merge

One big page

Noncontiguous pages

Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range. For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8

A range of pages within a section

Type p page number s section number. For example, to print pages 5 through 7 in section 3, type p5s3-p7s3

An entire section

Type s section number. For example, type s3

Noncontiguous sections

Type the section numbers with commas between them. For example, type s3,s5

A range of pages across sections

Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range. For example, type p2s2-p3s5

Labels: Merge, Printing

Different picture to every letter in a mail merge

1. Open the Excel worksheet that you use as the mail merge data source.
   
   
2. Insert a new column that has a column heading such as Picture.
   
   
3. For each row of the Excel worksheet, insert in the Picture column the path and the file name of the picture that you want to use for that record of the data source. Additionally, enclose the path and the file name in quotation marks (").
   
   For example, copy the path and the file name of the picture in Windows Explorer. Then, paste the path and file name into the Excel worksheet.
   
   Note The path and the file name of each picture in the Picture column will appear similar to the following example:
   
   "C:\Documents and Settings\username\My Documents\My Pictures\foldername\filename.jpg"
   
   
4. On the Edit menu, click Replace. Then, replace each instance of a single slash mark (\) with double slash marks (\\) in each path.
   
   For example, each path should now look similar to the following example:
   
   "C:\\Documents and Settings\\username\\My Documents\\My Pictures\\foldername\\filename.jpg"
   
   
5. Save and then close the Excel worksheet. Then, quit Excel.
   

1. Open the mail merge main document.
   
   
2. If the Excel data source is not attached, attach the data source. To do this, go to Step 3 of 6 in the Mail Merge task pane. Click Browse, and then attach the Excel data source.
   
   
3. Click Next: Write your letter.
   
   
4. In the mail merge main document, move the insertion point to the location where you want the picture to appear.
   
   
5. On the Insert menu, click Field.
   
   
6. In the Field dialog box, click IncludePicture under Field names, and then click OK.
   
   Note You may receive the following error message:
   
   Error! Filename not specified
   
   
7. Press ALT+F9 to display the field codes in the mail merge main document. You will see a field that is similar to the following field:
   
   { INCLUDEPICTURE \* MERGEFORMAT }
   
   
8. Move the insertion point into the field immediately following INCLUDEPICTURE.
   
   
9. Press the SPACEBAR, and then click More items on the Mail Merge task pane.
   
   
10. In the Insert Merge Field dialog box, click the picture merge field, such as Picture, and then click Insert.
    
    
11. Click Close to close the Insert Merge Field dialog box.
    
    The INCLUDEPICTURE field should now look similar to the following field:
    
    { INCLUDEPICTURE { MERGEFIELD "Picture" } \* MERGEFORMAT }
    
    
12. Press ALT+F9 to hide the field codes in the mail merge main
    
    
    
13. Click Next: Preview your letters.
    
    
    
14. Click Next: Complete the merge.
    
    
15. In the Mail Merge task pane, click Edit individual letters.
    
    
16. In the Merge to New Document dialog box, click OK.
    
    
17. On the Edit menu in the merged document, click Select All.
    
    
18. Press F9 to update the fields in the merged document.
    (Word mail merges are not dynamic)
    
    
19. To print your letters from the merged document, click Print on the File menu. Each printed letter will contain the picture that you specified in the Excel data source.

Labels: Merge

$ lost

If you don't see DDE, check Show all.

Also see:

Answer Box:
Numbers don't merge right in Word

and:

Cindy Meister:
Mail Merge FAQ

Here are some other Mail Merge resources:
Mail Merge Links



See all Topics
word

Labels: Merge

Mail merging creates multiple copies of the same document and inserts data from an external file or database. For example, printing a form letter for different recipients and including each recipient's name.
Word mail merge

FAQ about the mail merge feature in Word 2003 and in Word 2007 will help you learn how to use Mail Merge to create form letters, mailing labels, envelopes, or catalogs. It can also help you troubleshoot problems; and provides step-by-step instructions.

The Word MVP site has some more suggestions.

About.com:
Mail Merge
Creating Documents With Mail Merge

Cindy Meister:
Mail Merge FAQ



See all Topics
word

Labels: Merge

Demos

As part of their series of demos, Microsoft has information on creating mailing labels from a database, or mailing list.

Create labels with mail merge

Here is another entry concerning some of the fine points.

More label info

Also, if you place a graphic in the first cell, it will be duplicated in each box.



See all Topics
word

Labels: Merge

Custom content

• The curly brackets { } cannot be entered from the key board. Either use Insert>Field, or Ctrl+F9.
  
• Word uses spaces in the If..Then..Else statement.
  
• The last two quote marks "" are "empty" , so nothing will be entered.
  
• Notice the \\ in the path statement. A path is not needed if the Main document is in the same folder as the letters.
  
• To see the field codes, use Alt+F9 to toggle the view on and off.

Letters 1 and 2 can have completely different texts, formats and layouts. One can be an invitation to a sale, the other can be a dunning letter.
(To carry over different formatting, leave out the \* MERGEFORMAT switch)

After setting up the main document for mail merging, insert all of the fields you want to merge.

Copy the individual fields and paste them in the correct locations in Letter 1 and 2.

Go back to the main document and erase all of the text and fields EXCEPT for the IF statements.

Letters 1 and 2 do not have to be set up a merge docs, or connected to a data source. Their text will be inserted in the Main document depending on the field type.

Labels: Documents, Fields, Merge, Tutorials