BleepingComputer.com: Mail Merging Excel Sheet To Postcards

Jump to content

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 User is offline   Kat 

  • Member
  • PipPip
  • Find Topics
  • 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 User is offline   Rimmer 

  • Forum Addict
  • PipPipPipPipPipPip
  • Find Topics
  • 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 User is offline   tos226 

  • BleepIN--BleepOUT
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Members
  • Posts: 1,423
  • 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.

#4 User is offline   Rimmer 

  • Forum Addict
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Members
  • Posts: 2,159
  • Joined: 18-March 05
  • Location:near Sydney, Australia

Posted 10 November 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.
: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.

#5 User is offline   tos226 

  • BleepIN--BleepOUT
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Members
  • Posts: 1,423
  • Joined: 21-October 04
  • Gender:Female
  • Location:LocalHost

Posted 11 November 2005 - 05:52 PM

View PostRimmer, on Nov 10 2005, 01:29 AM, said:

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

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

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users