+ Reply to Thread
Results 1 to 3 of 3

mail merge

  1. #1
    Forum Contributor
    Join Date
    12-18-2015
    Location
    scotland
    MS-Off Ver
    MS office 365 business
    Posts
    187

    Arrow mail merge

    Hi All

    Using mail merge to print out about 100 certificates, firstly I converted the certificate pdf to a word document which allowed me to enter a text box to use as part of the mail merge, where I'm struggling is when I go to print I will be printing the whole document on to pre printed certificates.

    Is there a way to hide the background so as not print over the pre printed one

    Thanks

    Toddp

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: mail merge

    I suggest deleting the background that you don't want to print.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: mail merge

    Quote Originally Posted by tuph View Post
    I suggest deleting the background that you don't want to print.
    Agreed. This really has nothing to do with mailmerge, per se. Once the setup is done, the unwanted background should be deleted from the mailmerge main document before executing the merge - otherwise you might end up having to delete it from every merged record.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  2. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  3. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  4. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  5. Mail Merge Query - Format of Merge Fields in Word
    By carlosbourn in forum Excel General
    Replies: 2
    Last Post: 11-10-2007, 07:11 AM
  6. Replies: 0
    Last Post: 04-21-2006, 03:40 PM
  7. [SOLVED] merge with Word How can I get excel to mail merge zip codes plus 4 correctly?
    By Kathy at Sauder Feeds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2005, 07:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1