Another Excel query

[Madwitch]

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

 

[s0nicpr0s]

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

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?

 

[Madwitch]

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!