MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Spreadsheet to membership directory boolet


Posted by Kerry Walsh on January 31, 2002 4:37 PM

I belong to a whitewater rafting club and we maintain our membership directory in a plain old Excel spreadsheet. Now we want to publish a membership directory in a 5.5" x 8.5" booklet format. The format would be something like this:

Joe Blow
12345 N Easystreet
Anytown USA
Phone #
Email

Is there any way to use Excel to format the data suitable for printing?


Posted by anno on January 31, 2002 5:51 PM

john
i would use your excel spreadsheet as the data file for an ms word mail merge. i think some sort of label template would give you the layout you need. you can make your own label template which would give you the size and layout you need. i am a little rusty on mail merges but happy to provide any assistance i can.

alternatively, if you don't have too many members you could do a copy and paste special>transpose to change member details from rows to columns.

Posted by Kerry on February 01, 2002 8:53 AM

Thanks Anne,

We're on the same wavelength. I guess it's time to expand the horizons in my knowledge of Word.