Setting up data files for mail merge

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

starchild

Thread Starter
Joined
Sep 17, 2002
Messages
2,111
I just got into doing mail merge (learning it)- first from doing a tutorial that comes with Publisher (I have Office 2000), where there is a box to bring up to fill in the name, address, etc. of each person that will be in the file, and can then be included in the mailing (or labels, whatever)

This got me off Publisher (temporarily) because I knew Word did this (mail merge) but I'd never looked into it, thinking it was too complicated to figure out. I find it fascinating, the way the program(s) can do this. Print out from a file onto enevelopes, labels, etc. And, I'm reading, sort out specific ones to print and not print, too.

What I'm wondering is. There is a box that can be brough up (Wizard) to fill in each person's name, address, zip, phone, etc. for the file. Then the box is set up on the mailing, with the fields in it << >> to include from the file. Is there an easier, faster way of setting up the name, etc (data) file than typing in each name, address, etc separately in the boxes that come up?

I've never learned much about Excel and even less about Access, but I see it says the names, etc can be imported from these programs. And Outlook (or Outlook Express. I only have names and email addresses in OE) I suppose this would be typing the names and info in an Excel spreadsheet, in the cells? This would be converted into a mail merge file in Word or Publisher? (I don't want to go through all that if it's not going to work (LOL)

I can't think of any way of maybe copy/pasting the names and addresses, instead of typing it all in by hand, (where each line seems to be separate info) but I know so little about it, I could be missing something. Right now I'm not going to do a real mail merge or labels, I'm collecting names and addresses that I know, to set up in a practice file.

Someone asked me this a few years ago, if I knew how to do mail merge and if there was a way using Outlook Express file (which she apparently had mailing addresses, zips, etc in too) instead of retyping everything separately, line by line.

I didn't know how to do it at the time and I don't know if she ever found someone to do it (for her small business).

Thanks,
Carrie
 

WhitPhil

Gone but never forgotten
Trusted Advisor
Joined
Oct 4, 2000
Messages
8,684
See if this provides the lead for merging from OE into Word?

And, maybe this

And, this one has a 50 minute video on mail merge.
 
Joined
Feb 14, 2005
Messages
2
Check out code by Albert Kallal on Mail Merge from an Access database to Word. His is the best written, and the simplest to use by far!!!!!! Search for Albert Kallal Mail Merge on Google
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top