Help - Search - Members - Calendar
Full Version: Mail Merging Excel Sheet To Postcards
BleepingComputer.com > Software > Business Applications
   
Kat
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...

Rimmer
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 smile.gif
tos226
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.
Rimmer
tos226 - that step is not necessary, mailmerge can get the data straight from the Excel file provided the columns have headings.
smile.gif
tos226
QUOTE(Rimmer @ Nov 10 2005, 01:29 AM) *
tos226 - that step is not necessary, mailmerge can get the data straight from the Excel file provided the columns have headings.
smile.gif

Funny thing is, I've done it straight from Excel several times ... whoa, I'm losing it I think.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.