+ Reply to Thread
Results 1 to 2 of 2

Custom Formatted - Printed Customer List

  1. #1
    Registered User
    Join Date
    09-10-2023
    Location
    Ottawa,Ontario,Canada
    MS-Off Ver
    365
    Posts
    1

    Custom Formatted - Printed Customer List

    I need to produce a customized printed list of about 600 members from an Excel spreadsheet. I have been given a copy of the preferred page layout used in a former, no longer available, MS ACCESS application. Each page has about 6-7 blocks of unique information: member's names, addresses and other info.

    I thought MS Word might have something in Mail Merge that I could use but that seems to be limited to, well, only mail. Any suggestions for a newbie?
    Maz

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Custom Formatted - Printed Customer List

    Welcome to the forum.

    You can merge data from Excel to Word and then output that as a printed document. To be more specific, we'd need to see a sample of the desired layout and some sample (desensitised) data.

    Have a look here: https://www.ablebits.com/office-addi...ge-excel-word/

    Output would be to a DIRECTORY (about halfway down).
    Last edited by AliGW; 09-12-2023 at 09:35 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Code needed to replace all Custom formatted cells with currency formatted cells
    By dsrt16 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2018, 02:15 AM
  2. Generate a separate staff customer list based on larger customer table
    By CARROLLJP in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2018, 04:40 PM
  3. sorting a list of customer invoices from columns into rows / customer
    By jr1984 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2011, 07:04 AM
  4. Customer Names into Customer List
    By dustin470 in forum Excel General
    Replies: 2
    Last Post: 02-13-2010, 08:52 AM
  5. Custom Footer - Printed by...- how to
    By Mada in forum Excel General
    Replies: 4
    Last Post: 08-08-2007, 10:56 AM
  6. [SOLVED] CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET
    By brunod in forum Excel General
    Replies: 1
    Last Post: 07-07-2006, 02:10 PM
  7. [SOLVED] How To Make A Customer List With Extra Entries Per Customer
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2005, 03:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1