|
How can I create a class reunion directory from a spreadsheet?
I have set up personal data in columns that are titled classname, present
name, address, phone, email, occupation, children, grandchildren, interests, etc. for a high school class reunion directory. How can I turn this into a layout whereby it prints on pages and looks like this: SMITH, Brenda (bold face and underlined) COWELL, Brenda 3220 Main Street Columbus, OH 43007 614-228-3223 Business Owner Spouse: John Cowell Tom (32), Bob (30), Sally (28) Emily (7); Sammy (4) Bridge, Reading, Tennis If possible, I would like the layout to show two columns across the page, such as: SMITH, Brenda JONES, George COWELL, Brenda JONES, George 3220 Main Street 579 Chester Boulevard Columbus, OH 43007 Albany, NY 45862 614-228-3223 253-954-7888 Can anyone help? I've been using Excel for the past year or two, but am no whiz! Thanks much. |
How can I create a class reunion directory from a spreadsheet?
I think I'd spend some time looking at mail merge in MSWord.
Here are a couple of links: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. BRENDA wrote: I have set up personal data in columns that are titled classname, present name, address, phone, email, occupation, children, grandchildren, interests, etc. for a high school class reunion directory. How can I turn this into a layout whereby it prints on pages and looks like this: SMITH, Brenda (bold face and underlined) COWELL, Brenda 3220 Main Street Columbus, OH 43007 614-228-3223 Business Owner Spouse: John Cowell Tom (32), Bob (30), Sally (28) Emily (7); Sammy (4) Bridge, Reading, Tennis If possible, I would like the layout to show two columns across the page, such as: SMITH, Brenda JONES, George COWELL, Brenda JONES, George 3220 Main Street 579 Chester Boulevard Columbus, OH 43007 Albany, NY 45862 614-228-3223 253-954-7888 Can anyone help? I've been using Excel for the past year or two, but am no whiz! Thanks much. -- Dave Peterson |
How can I create a class reunion directory from a spreadsheet?
"Dave Peterson" wrote: I think I'd spend some time looking at mail merge in MSWord. Here are a couple of links: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. BRENDA wrote: I have set up personal data in columns that are titled classname, present name, address, phone, email, occupation, children, grandchildren, interests, etc. for a high school class reunion directory. How can I turn this into a layout whereby it prints on pages and looks like this: SMITH, Brenda (bold face and underlined) COWELL, Brenda 3220 Main Street Columbus, OH 43007 614-228-3223 Business Owner Spouse: John Cowell Tom (32), Bob (30), Sally (28) Emily (7); Sammy (4) Bridge, Reading, Tennis If possible, I would like the layout to show two columns across the page, such as: SMITH, Brenda JONES, George COWELL, Brenda JONES, George 3220 Main Street 579 Chester Boulevard Columbus, OH 43007 Albany, NY 45862 614-228-3223 253-954-7888 Can anyone help? I've been using Excel for the past year or two, but am no whiz! Thanks much. -- Dave Peterson |
How can I create a class reunion directory from a spreadsheet?
Thanks for a prompt response. I'll give those sites a try.
"Dave Peterson" wrote: I think I'd spend some time looking at mail merge in MSWord. Here are a couple of links: http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. BRENDA wrote: I have set up personal data in columns that are titled classname, present name, address, phone, email, occupation, children, grandchildren, interests, etc. for a high school class reunion directory. How can I turn this into a layout whereby it prints on pages and looks like this: SMITH, Brenda (bold face and underlined) COWELL, Brenda 3220 Main Street Columbus, OH 43007 614-228-3223 Business Owner Spouse: John Cowell Tom (32), Bob (30), Sally (28) Emily (7); Sammy (4) Bridge, Reading, Tennis If possible, I would like the layout to show two columns across the page, such as: SMITH, Brenda JONES, George COWELL, Brenda JONES, George 3220 Main Street 579 Chester Boulevard Columbus, OH 43007 Albany, NY 45862 614-228-3223 253-954-7888 Can anyone help? I've been using Excel for the past year or two, but am no whiz! Thanks much. -- Dave Peterson |
| All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com