ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you create a list with name address phone in a column form. (https://www.excelbanter.com/excel-discussion-misc-queries/17583-how-do-you-create-list-name-address-phone-column-form.html)

denise108

How do you create a list with name address phone in a column form.
 
I have an excel file with last name, first address city state in each column.
I want to prepare a two column report with each persons name first then
address then phone. Can't remember how to print out a different view of
excel. Making it look more like a two column word document.

Dave Peterson

Maybe you can use MSWord's MailMerge.

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.

denise108 wrote:

I have an excel file with last name, first address city state in each column.
I want to prepare a two column report with each persons name first then
address then phone. Can't remember how to print out a different view of
excel. Making it look more like a two column word document.


--

Dave Peterson


All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com