+ Reply to Thread
Results 1 to 3 of 3

Mail Merge Alternatives????

  1. #1
    Spammer
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    387

    Mail Merge Alternatives????

    I am looking to automate the creation of a client check in "card" and not sure if there is a way to do it in Excel?

    I realize i can do Mail Merge from Excel to Word but did not know if there is a way to do this without leaving Excel?

    Ideally would want to be able to highlight a row, or check a box next to a client name, and then hit "print" and have it formatted in such a way that it would print out the card. Just not sure if there is an ability to do this in excel?

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Mail Merge Alternatives????

    No there isn't. That's what mail merge is for as you've quite rightly identified.

    You'd need to write code to do this for you in Excel, which is more complex and error prone than mail merge

  3. #3
    Spammer
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    387

    Re: Mail Merge Alternatives????

    Thank you Kyle. I was afraid of that, but appreciate the info.

    Is there a way to make a mail merge happen and send data to Word, print, etc by selecting a row in Excel (via check box or ??) and hitting the "Print" button?

    Out of a 130 column file, there will need to be 24 cells printed in the mail merge...

+ 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: 5
    Last Post: 11-15-2018, 10:54 PM
  2. Mail Merge Directory - Creating merge with multiple lines
    By tiggynook in forum Excel General
    Replies: 3
    Last Post: 05-03-2017, 03:00 PM
  3. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  4. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  5. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  6. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  7. Replies: 0
    Last Post: 04-21-2006, 03:40 PM

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