Exporting Excel to Word
Here's the idea:
I was given an Excel spreadsheet with the following columns:
Lastname, Firstname, Address, City, State, Zip
I need to print mailing labels from this info
Easy enough, I've found
The hard parts:
Removing duplicates
Printing more than 1 label per sheet
How I have it set up:
I put all the info into a Mailmerge DB and can get it to output labels , but only 1 per sheet, which, with over 300 addresses is a big waste of space
Any programs you can suggest?
Any modifications you can suggest??
Thanks!
nike_guy_man posted this at 22:25 — 15th December 2002.
They have: 840 posts
Joined: Sep 2000
Nevermind I figured it out
Busy posted this at 08:28 — 16th December 2002.
He has: 6,151 posts
Joined: May 2001
How did you end up doing it?
nike_guy_man posted this at 23:34 — 16th December 2002.
They have: 840 posts
Joined: Sep 2000
Imported the 4 excel files into an Access DB -- Horrible program
Sorted by name, deleted duplicates
Used Word's Mail Merge feature and put the Access DB as the mail merge DB...
Printed and voila!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.