Forum Discussion

Hotes's avatar
Hotes
Copper Contributor
Aug 02, 2022

personal check printing

I am attempting to create a way to print my pre-printed personal bank checks.  I want to leave everything that is pre-printed on the check, load that check into my printer, and then type into Excel t...
excel
mathetes's avatar
mathetes
Silver Contributor
Aug 04, 2022

Hotes 

 

Why Excel? Why not Word? And if you are wanting to do multiple checks or repeating this on a scheduled (e.g., monthly) basis, use Excel as the source for a Word Mail Merge.

 

The reason I would suggest Word: you will have a lot more control over placement of the text in Word. There may even be (or you could create) a template that is designed for pre-printed checks.

Hotes's avatar
Hotes
Copper Contributor
Aug 04, 2022

Thanks for your input, but I don't know how to do it on word either lol mathetes 

  • mathetes's avatar
    mathetes
    Silver Contributor
    Aug 04, 2022

    Hotes 

    I don't know how to do it on word either

     

    As I said, the formatting--getting things to print in the right spaces--would be easier to control in Word, though it would take some tinkering.

     

    But you could also do what I just did and google the request for templates for check printing. One result, of many, is the one linked here.  That link includes instructions for how to use the Excel template that you can download free.

    • Hotes's avatar
      Hotes
      Copper Contributor
      Aug 08, 2022

      Thanks for that link.  It works well.  Now if I can only get my printer to co-operate lol mathetes 

    • Hotes's avatar
      Hotes
      Copper Contributor
      Aug 05, 2022
      Thanks for your help, but these things are a pain in the butt for me. I wish someone would make an easy-to-use program where a person can take their personal bank checks, put them in a printer of any kind, open the software, type the info in, and voila, the check comes out with the correct info on it. It should be as easy as writing the check out of your checkbook but using a printer to do it.
      • GeorgieAnne's avatar
        GeorgieAnne
        Iron Contributor
        Aug 05, 2022
        Hello Hotes,
        I do second mathetes suggestion of MS-Word mail merge from a MS-Excel worksheet. I would start here and let us know how far you get and we can help you along the way. I tell you the best way to learn is by using all your faculties and sooner than later you will have your own custom made solution and will be able to maintain it and add features to it.

        Look here for suggestions:
        https://support.microsoft.com/en-us/office/mail-merge-using-an-excel-spreadsheet-858c7d7f-5cc0-4ba1-9a7b-0a948fa3d7d3
        https://support.microsoft.com/en-us/office/prepare-your-excel-data-source-for-a-word-mail-merge-2d802b6b-a3a3-43e5-bb76-2cac7c68673e
        https://www.ablebits.com/office-addins-blog/mail-merge-excel-word/
        https://www.youtube.com/watch?v=0XifMrBegS0
        https://www.youtube.com/watch?v=mFqCvTOpOL0

        Once you get started you will enjoy this project and remember we are all here for you to ask questions and get advise. After this, we will be asking you for help! Go for it...

Resources