Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, February 10, 2008 – Permalink –

Merge to More than One Document

Custom content



In the Data Source, include a field for the type of letter the recipient requires.

In the Main merge document, enter IF fields, such as:

{IF {MERGEFIELD "LetterType"=1} {INCLUDETEXT "C:\\Project\\Letter1" \* MERGEFORMAT} ""}
{IF {MERGEFIELD "LetterType"=2} {INCLUDETEXT "C:\\Project\\Letter2" \* MERGEFORMAT} ""}



  • 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.





See all Topics

Labels: , , ,


<Doug Klippert@ 7:32 AM

Comments: Post a Comment


  Wednesday, December 26, 2007 – Permalink –

Page Breaks

Demo tutorial


You can control when Word decides to break for a new page.

Ctrl+Enter is the keyboard shortcut, but there are a number of variations.


This MS link has both Demos and text tutorials.
Page breaks

BTW; a merged document is made up of Section breaks, not Page breaks.

For ease of printing, Replace ^b with ^m



See all Topics

Labels: , , ,


<Doug Klippert@ 6:35 AM

Comments: Post a Comment


  Tuesday, October 23, 2007 – Permalink –

Tab Leader

You can lead a tab to ...........


Setting Tab Leaders in Word


Fred Smith.........................$44.59


This makes your list easier to read


  1. Select the line on which you want to create a tab

  2. Click on the Format menu and click on the Tabs menu item
    (you will see the Tabs dialog box)

  3. In the Tab Stop Position field enter the distance to the last column: 5", 6" or what ever is appropriate

  4. Then select the tab alignment; Decimal, Right, Center or Left

  5. Select the type of leader to use

  6. Click Set and then OK


Enter the name, or first entry, and then touch the Tab key.

Word will automatically enter as many leading characters as required.

When you can type the amount, it will be aligned on the decimal or any other alignment you might have chosen.

Here's what it looks like in Word 2007





Also:

University of Florida handout:
Word Tabs Doc

WordTips Online Answers:
Tips on Word tabs

OfficeLetter.com:
Favorite Word tips #2

About.com:
Creating Tab Leader Lines


Fab Tabs
Uncover the magic of using tabs



See all Topics

Labels: ,


<Doug Klippert@ 6:50 AM

Comments: Post a Comment


  Friday, September 07, 2007 – Permalink –

Compare-Combine

Changes in '07


For a number of reasons, including collaboration, documents need to be reconciled. A resultant or master document must be distilled from different versions.

Here are some directions:

Compare - Combine

Comparing and Combining Documents


Back in the old days of 2003, you could save "versions" of documents. That's gone:
Bye-Bye Versions



See all Topics

Labels:


<Doug Klippert@ 7:46 AM

Comments: Post a Comment


  Sunday, August 26, 2007 – Permalink –

Resume writing

Get a Job



There are a number of templates installed in Word that will help in creating a good looking resume.
Get started on your job hunt with Word templates


Here are some suggestions about what a resume should look like:

The Rockport Institute:
How to Write a Masterpiece of a Resume

About.com
Resume and Cover Letter Guide

The Riley Guide:
Prepare Your Resume for Emailing or Posting on the Internet

If your job is to collect job applications, look at:

MSDN:
Creating and Applying an XML Resume Template in Microsoft Office Word 2003

Word 2003: Sample XML Resume Template

Smart Documents Resume Sample Application


Want to work for Microsoft?

Microsoft's Zoe Goldring and Gretchen Ledgard:
What is it like to interview at Microsoft?

Chris Sells:
Interviewing at Microsoft Blog:Technical Careers@Microsoft

The real first impression
The journey of a resume



See all Topics

Labels: , ,


<Doug Klippert@ 7:08 AM

Comments: Post a Comment


  Friday, June 01, 2007 – Permalink –

Document Panes

Divided Doc


To divide the view of a document into panes, use the tiny divider mark in the upper-right corner of the document window.

It's above the up arrow at the top of the vertical scroll bar at the right side of the window.

Click on the marker and drag it to where you want the document window divided.

The size of the panes can be adjusted by dragging the divider up or down.

You can look at the top and bottom at the same time, or have one pane in Page View and the other in Outline View

Double click the marker to return to the full view.



See all Topics

Labels: ,


<Doug Klippert@ 7:08 AM

Comments: Post a Comment


  Wednesday, March 21, 2007 – Permalink –

Citation and Bibliography

2007 feature


"What if you write a paper for your literature class, but an educational journal wants to publish it? You used MLA style for formatting the citations and bibliography, but the journal uses APA style. It would be tedious to edit every citation and revise the bibliography to switch them from one style to the other. Fortunately, Office Word 2007 can switch bibliography styles. Choose a different style, and Word automatically reformats all the citations and the bibliography.

What about the next time that you write a paper on a related subject? If your specialty is Mark Twain, you will probably cite many of his same works in more than one paper. Word stores your master list of sources for you. Whenever you start a new paper, you can choose from your list of sources for the citations that you make in that paper."





Academic features: citation & bibliography tools


Previous versions
Footnote, Endnote, and Bibliography Questions



See all Topics

Labels:


<Doug Klippert@ 6:55 AM

Comments: Post a Comment


  Tuesday, February 13, 2007 – Permalink –

Open 2007 with 2003-2000

Not everyone is going to jump at once


How to open and to save Word 2007, Excel 2007, and PowerPoint 2007 files in earlier versions of Office
Microsoft Office Word, Microsoft Office Excel, and Microsoft Office PowerPoint versions 2000 through 2003 cannot natively open documents that are stored in the Office Open XML Formats in 2007 Microsoft Office programs.

You can install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats to open or to save 2007 Office files.

Microsoft Office XP and 2003
Word, Excel, and PowerPoint

After you install the Compatibility Pack, you can use your existing version of Word, Excel, and PowerPoint to open, edit, and save the file formats that are new to Word 2007, Excel 2007, or PowerPoint 2007. For example:
  • You can open Word, Excel, or PowerPoint 2007 files by double-clicking them exactly as you do with your existing Word, Excel, and PowerPoint presentation(s).
  • You can save Word, Excel, or PowerPoint 2007 files by clicking the Save button in your version of Word, Excel, or PowerPoint.


Microsoft Office 2000
Word, Excel, and PowerPoint

Word 2000
  • After you install the Compatibility Pack, you can open, edit, and save the document file formats that are new to Word 2007 within Word 2000.
  • You can open files in the formats that are new to Word 2007 by double-clicking the files.
  • You can save files in the formats that are new to Word 2007 by clicking Save in Word 2000.


Excel 2000 and PowerPoint 2000
  • After you install the Compatibility Pack, you can open and save the file formats that are new to Excel 2007 and to PowerPoint 2007 from the Microsoft Windows operating system.
  • You can open files in the formats that are new to Excel 2007 and to PowerPoint 2007 by double-clicking the file on the desktop, in the My Documents folder, or in Microsoft Windows Explorer.
  • You can save files in the formats that are new to Excel 2007 and to PowerPoint 2007 by right-clicking an Excel 2000 file or a PowerPoint 2000 file and then clicking Save As.


Compatibility Pack Functions

Compatibility Pack Download



See all Topics

Labels: ,


<Doug Klippert@ 7:25 AM

Comments: Post a Comment


  Tuesday, January 16, 2007 – Permalink –

Large Documents

Plan ahead


Jack M. Lyon has prepared a list of steps to be considered when working with large documents:
"I can't leave the topic of typesetting without explaining some of the things I learned on the last book I typeset--in Microsoft Word. The book had more than 400 pages and several hundred footnotes, and Word would have handled it better if I'd been more particular about the following:"


Typesetting Tips for Word


Charles Kenyon has some more tips including don't use Master Documents.

Master Documents


Master documents are available in 2007, (in Outlineview), but I have not tried the feature yet.


See all Topics

Labels:


<Doug Klippert@ 6:08 AM

Comments: Post a Comment