BleepingComputer.com: Mail Merging Excel Sheet To Postcards

Having entered data on an Excel spreadsheet (Excel 2000), how the heck can I pull it over via mail merge (into a Word doc?) and onto a pre-printed postcard billing? Can I juggle the locations of all the fields needed to print onto the postcard so that they fall into the right spot, upon printing?

Here's what the postcard looks like...

That should be possible, so long as you have a printer that can print on those postcards...

A quick Google found these tutorials which should help:

http://www.facsup.armstrong.edu/jobaidpdf/wordmailmerge.PDF

and a video tutorial
http://www.mistupid.com/technical/mailmerge/index.htm

- it seems the key step is producing a form letter in Word so the field layout corresponds with the printed form.

hth

Assuming that Word doc is designed to print this postcard, as Rimmer says, and assuming that excel holds a list of people and addresses, you need to get the list into Word, right? Make Excel put the list out for you as a .txt file or .csv (comma separated values) file and tell Word to take that list and use it in its placeholder variables.

tos226 - that step is not necessary, mailmerge can get the data straight from the Excel file provided the columns have headings.

Rimmer, on Nov 10 2005, 01:29 AM, said:

Funny thing is, I've done it straight from Excel several times ... whoa, I'm losing it I think.