+ Post New Thread
Results 1 to 2 of 2
Windows Thread, Mail Merge with Office 2003 in Technical; We have just started to use our print management system to charge staff if they print more than 200 pages. ...
  1. #1

    Join Date
    Oct 2005
    Location
    Hull, East Yorkshire
    Posts
    23
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Mail Merge with Office 2003

    We have just started to use our print management system to charge staff if they print more than 200 pages. I am trying to create a mail merge to tell them who printed, how much it will cost and which department it will be billed to.

    The problem is I can't find a way to only import records into the mail merge if users print more than 200 pages, then charge the staff for any pages over the 200 quota they print.

    Can you use IF statements in Word or do I need to use a more complex way to do this?

    Thanks

  2. #2
    altecsole's Avatar
    Join Date
    Jun 2005
    Location
    Whittington, Lancashire
    Posts
    284
    Thank Post
    39
    Thanked 36 Times in 26 Posts
    Rep Power
    25

    Re: Mail Merge with Office 2003

    How about this?

    Save your data into Access (or similar) and then run a query for those who have printed more than 200 pages. Use the query as your data source for the merge.

SHARE:
+ Post New Thread

Similar Threads

  1. Mail merge and pictures
    By GrumbleDook in forum Educational Software
    Replies: 11
    Last Post: 4th February 2009, 11:13 AM
  2. Running Office 2003 and Office 2007
    By mrforgetful in forum Office Software
    Replies: 17
    Last Post: 12th June 2008, 01:11 PM
  3. Mail Merge
    By Teaboy in forum MIS Systems
    Replies: 4
    Last Post: 12th November 2007, 06:32 PM
  4. Mail Merge Office 2003
    By karldenton in forum Windows
    Replies: 5
    Last Post: 18th June 2007, 08:26 AM
  5. Replies: 6
    Last Post: 28th September 2006, 07:06 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •