Friday, August 12, 2005

How to make a mailing?

Today I will learn you how you make a mailing with Office 2003 or XP. Or a letter for different people. You need 1) MS-Access or MS-Excel. And 2) MS-Word.

There or two ways to make a mailing, with access or with excel. First I’ll do it with excel.

I explain it in steps, so just follow me ;)




Today I will learn you how you make a mailing with Office 2003 or XP. Or a letter for different people. You need 1) MS-Access or MS-Excel. And 2) MS-Word.

There or two ways to make a mailing, with access or with excel. First I’ll do it with excel.

I explain it in steps, so just follow me ;)

1) Open a new Excel file an type your addresses here. Do it in columns and name your columns like ‘Name, Address, Zip code (Postcode), City’. Save it somewhere on your pc.

2) Type your letter in MS-Word and hold place for the addresses.

3) Go to: ‘extra – letters en send lists – mail merge’ you’ll now see a box on the right with a wizard, where you can select your type of letter. In this example we’re going to make a casual letter’. Click at the bottom on ‘next’ so you go to step 2 from 6. Select start document and you chose ‘use current document and click next on the bottom’.

4) ‘select addresses’ ‘use an existing list’, select and open your excel-file and click in the new window ‘OK’ after you selected the addresses you want. Click next.

5) Place your cursor on the place you want your address and then you take the first option in blue: ‘address block’ Then you get a new window ‘insert address block’ Press OK if you are pleased with the example. You see on the place where the cursor stays now ‘address block’.

6) Click now in the box on the right at the bottom and you see the address is placed on the free holding place, and click next.

7) now you see 2 blue texts ‘print and edit separate letters’ you click on the second. ‘Edit separate letters’.

8) you get a new box and you press OK. there's now a new document with a custom version for each of the addressees

9) you can save this new document or print al the letters. The original document with your letter can you save also without al the different letters (only the basic letter)


You prefer to work with MS-Access?
(I suppose that you have made already a table with the addresses in MS-Access.)

To do this trick with Access you need to do the same as above, except you have to chose your access-file in stead of an excel file.

Sneakytje

3 Comments:

At Sunday, 02 October, 2005, Blogger freestuff2 said...

You have a nice blog here. Did you know
there Is A 90% Chance That Your Computer Has AdWare Or Spyware On It Right NOW!

Spyware and Adware viruses have rapidly become the number one threat to your computer with over 90% of computers already infected. These include trojans, bugs, ad serving software, monitoring software and more.
I also have a microsoft anti spyware beta site-blog. It can help you find and get rid of spyware, adware plus other stuff pn your computer for good. Free downloads.
You should check it out if you get the time!

 
At Sunday, 30 October, 2005, Blogger brian said...

I like the page you have here. Check mine out data recovery san

 
At Monday, 31 October, 2005, Blogger The Computer Guys said...

Yo, you have a Terrific blog here! Lots of content means more readers, more readers means more Sales!
I'm definitely going to bookmark you!
I have a window xp networking helpwindow xp networking help site/blog. It pretty much covers window xp networking help Problems with your Windows Xp Computing !
Come and check it out if you get time We are just a Click Away ! :-)

 

Post a Comment

<< Home