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

0 Comments:

Post a Comment

<< Home