BleepingComputer.com: Mail Merging Excel Sheet To Postcards

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Mail Merging Excel Sheet To Postcards Can it be done?

#1 Kat

Member

Group: Members
Posts: 126
Joined: 03-January 05

Posted 29 October 2005 - 02:11 PM

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...

Posted Image

#2 Rimmer

Forum Addict

Group: Members
Posts: 2,159
Joined: 18-March 05
Location:near Sydney, Australia

Posted 29 October 2005 - 11:28 PM

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 :thumbsup:

Soltek QBIC, Pentium 4 3.0GHz, 512MB RAM, 200GB SATA HDD, ATI Radeon 9600XT 256MB, Netgear 54Mb/s WAP, ridiculously expensive Satellite Broadband
Windows XP Home SP2, Trend Micro Internet Security, Firefox, Thunderbird, AdAwareSE, Spybot S&D, SpywareBlaster, A-squared Free, Ewido Security Suite.

#3 tos226

BleepIN--BleepOUT

Group: Members
Posts: 1,412
Joined: 21-October 04
Gender:Female
Location:LocalHost

Posted 09 November 2005 - 11:21 PM

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.