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



  Saturday, January 31, 2009 – Permalink –

Kürzungen für jeder

Accessibility Shortcuts


Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.

  • Internet Explorer 7/6/5/4
  • Office (2007/2003/XP/2002/2000/97)
  • PhotoDraw
  • PowerPoint
  • Producer
  • Publisher
  • Windows (Vista/2003/XP/2000/98/ME/NT)
  • Windows Media Player
  • Windows Movie Maker
  • Windows XP Media Center Edition 2005
Microsoft.com Keyboard Assistance.



See all Topics

Labels:


<Doug Klippert@ 3:28 AM

Comments: Post a Comment


  Tuesday, January 27, 2009 – Permalink –

Mail Merge Page Printing

One big page


After completing a merge to a new document, the status bar may indicate that the insertion point is located on page 1 of 38 pages. This is a bit of mis-information.

If you turn on Show/Hide and look at the merged document in Normal view, you'll see that the merged document has section breaks rather than page breaks.

If you try to print what should be Page 1, the entire document will print.

To print just the first section, use "s1" in the Print dialog box.



Another way to handle it is to go to Edit>Replace and replace

"^b" (section break)

With

"^m" (manual page break)



From Office.Microsoft.com:
In the Pages box, type instructions to print one of the following:


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




See all Topics

Labels: ,


<Doug Klippert@ 3:51 AM

Comments: Post a Comment


  Monday, January 26, 2009 – Permalink –

Graphics from the '50s

Remember it the way you want to


Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.



"Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser's needs."

Retrographix.com




See all Topics

Labels:


<Doug Klippert@ 3:32 AM

Comments: Post a Comment


  Monday, January 19, 2009 – Permalink –

Merge Pictures

Different picture to every letter in a mail merge



A variation of this technique could also be used with an IF statement to display different pictures based on some criteria, such as Zip code.
  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.
In Word, follow these steps:
  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.
Knowledgebase #909132: Different picture to every letter in a mail merge




See all Topics

Labels:


<Doug Klippert@ 3:48 AM

Comments: Post a Comment


  Tuesday, January 13, 2009 – Permalink –

Almost All You Need to Know

Collection of Word explanations



Shauna Kelly is a Microsoft Word MVP.

She has compiled a gathering of important Word how to's and whys.


For new users of Microsoft Word
Basic concepts - Introduction
Styles in Microsoft Word
Tips for understanding styles
Formatting
How the Styles and Formatting pane works
Numbering, Bullets, Headings, Outlines
How to control bullets
Templates
What is the relationship between a Word document and its template?
Layout
How to keep a figure on the same page as its caption
Sharing Microsoft Word documents
What happens when I send my document to someone else?


Making the most of Word in your business:
Microsoft Word FAQ



See all Topics

Labels: , ,


<Doug Klippert@ 3:23 AM

Comments: Post a Comment


  Tuesday, January 06, 2009 – Permalink –

Clip Art Gallery

Sprinkle carefully


Judicious use of Clip art can spice up a document. Here's an article about how to customize existing pictures including:
  • Display clip-related toolbars
  • Customizing your clip art
  • Cropping
  • Sizing
  • Adding text wrapping
  • Blurring
  • Rotating and flipping
  • Adding a drop shadow
Edit clip art in Word

Also:
Clip art gallery

 

Halloween clips
Clip Art demo
5 new things about the Clip Art and Media site
Mary Sauer's Design Gallery Help
Microsoft Clip Art & Media Help




See all Topics

Labels:


<Doug Klippert@ 3:22 AM

Comments: Post a Comment


  Sunday, January 04, 2009 – Permalink –

Split View

Top and bottom


If you need to look at more than one part of a document at once, consider splitting the window.

To split the current window, just go to Window>Split from the main menu.
(View>Split in 2007)

Another way is to use the splitter control between the file tab channel and the scroll bar for the doc.



To create new windows for the same document, just go to Window>New Window and create as many views on the same document as you would like. (View>New Window in 2007)

WebJunction.org:
Word Split Window
(Publisher: The Bill and Melinda Gates Foundation)

Also:
Dawn Ontario, Disabled Women's Network:

Split Screen Feature - Microsoft Word



See all Topics

Labels: , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment