Another Excel query

Discussion in 'Mac Apps and Mac App Store' started by Madwitch, Apr 5, 2016.

  1. Madwitch macrumors newbie

    Madwitch

    Joined:
    Feb 4, 2013
    Location:
    North Yorkshire, UK
    #1
    Hi. Anyone any idea if you can use an excel spreadsheet as the main document in a mail merge? I know you can use excel for the data document, but I have a form in excel which I need to complete about 1000+ times. I've tried to import it into Word, but the formatting changes, so if possible I want to keep the form in excel and complete it using mail merge. TIA
     
  2. s0nicpr0s macrumors regular

    s0nicpr0s

    Joined:
    Sep 1, 2010
    Location:
    Illinois
    #2
    Just curious, what type of information are you trying to move from the spreadsheet? Is it the full form? Or the information that gets inputted to the form?
     
  3. Madwitch thread starter macrumors newbie

    Madwitch

    Joined:
    Feb 4, 2013
    Location:
    North Yorkshire, UK
    #3
    It's a certificate for electrical inspection testing results. Most of the information is already laid out on the form, and I need to input approx 12 values in each form - but I've got well over 1000 to do! Whilst I'll still have to type out the values even if I use a data sheet, I can do this much more quickly than having to keep checking which cell I'm typing it in!
     

Share This Page