Printing bank checks?

[AC]

Hi, does anyone have a worksheet, or know where to get one, set up to print bank checks? I am using Excel '97. Thanks

[ This Message was edited by: AC on 2002-05-05 08:54 ]

[Anne Troy]

Some may argue with me, but I think this job will be much easier using a mailmerge with Word.

Scan one of your bank check sheets and put it into the header of a Word document/centering it exactly on the page.

Set up a mailmerge with your Excel workbook. Exact instructions here:
http://www.thewordexpert.com/word.htm#MailMerge
You'll need to tweak yours a bit, and I'll be here all day to help if you need it.

But when you're done, you can easily check the ones you want to pay in the Excel file, and run the mailmerge.

To do it completely in Excel does, I believe, require VBA. I've also seen this question before, where the VBA may exist, so you might want to search the site here for that.

[Jack in the UK]

im surprised your accounting software does not do this>> no accounting SW>???

Sage is the world leader in this and willdo this at a snip but cost $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ or even more $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$4

Excel of cause can do this with ease, but will require complex VBA, and i would use excepl as data source, and use a triger to sat YES chq or skip, and get WORD to do the task for you can be one in one in a list or add selection and have manual input via customer number

To add Dreamboat is dead on, WORDS power is Merge and of cource lables, VERY very VERY good/