Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a sound alert in excel spreadsheet | Excel Discussion (Misc queries) | |||
How Do I create a spreadsheet with a finite set of columns and ro. | New Users to Excel | |||
Can I create custom forms to add data to a Excel Spreadsheet? How. | Excel Discussion (Misc queries) | |||
How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions | |||
How do I create spreadsheet that automatically updates numbers/va. | Excel Discussion (Misc queries) |