export query to CSV for label generation

Discussion in 'MySQL' started by mik cohen, Oct 10, 2006.

  1. #1
    Hello,

    I do not know the best way to generate labels from a MySQL query.

    I created a member database for the Darwin Homebirth Group and part of this involves sending out membership reminder letters every year. Thus I need to query the database to see who is due (not everyone) and somehow get that information into CSV or Excel so it can be used as a data source for MS Word Label generation.

    Any suggestions??? :confused:
     
    mik cohen, Oct 10, 2006 IP
  2. rosytoes

    rosytoes Peon

    Messages:
    230
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    do your query, output your answers (names,addresses) into a text file in the form of a Word MailMerge document. Then merge your data into your labels format and print.
     
    rosytoes, Oct 11, 2006 IP