Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Mail Merges

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Carole
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you tell me how to get data from a spreadsheet in to a word document. The spreadsheet has been filtered to only show items due in the month of May. My colleague and I have tried and we either get all of the spreadsheet data or none (data source is empty message?)

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Liverpool UK
    Posts
    66
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Copy the filtered results to a new worksheet,name it mail merge, save, open word 'tools' mail merge, choose document,choose data source(your excel file)choose the work sheet 'mail merge', add the fields you want to the word document, save as new document or to printer.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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