[[email protected]]

The sofware im using is all office 2000

I have a Excel file with email address and various other pieces of
information ie name.
I want to merge these into various emails, one to each address with
different information inside.
I cannot work out how to do this, does anyone know of a good guide? Or
can you give me some ideas to play around with.

The end product will be 190 emails to seperate addresses with different
information but the same letter in each. I can create the letters but
dont want to have to type out the 190 email addresses!

Cheers in advance for any help...

Cal

[Peter Jamieson]

It should be fairly straightforward, except that you may have to do
something special to make Word merge specifically to e-mail. If your
e-mailer is anything other than Outlook or Outlook Express you are more
likely to run into difficulties.

To get going,
1. Open Word. Let's assume it opens displaying a blank document (typically
"Document1"). Let's also assume that your data is in the first sheet of your
Excel workbook
2. Start Tools|Mail Merge. You then see a dialog box call the Mail Merge
Helper , with 3 steps
3 Click Create and Select Form Letters. Click "Active Window" on the dialog
box that appears
4. Click Get Data, then Open Data Source... You see a file selection dialog
box. Select "MS Excel Worksheets (*.xls) in the "Files of Type" dropdown,
then naivate to your .xls file and select it.
5. Make sure "Select method" is unchecked, then click Open. Word should
start Excel and open the data source. A further dialog box should appear
saying "Entire Spreadsheet" (if you're using a non-English language version
of Windows/Office look for the equivalent expression). Click OK.
6. You then see a dialog box saying that Word found no merge fields in your
main document. Click "Edit Main Document."
7. You can now create your document layout. You will notice that a new
toolbar has appeared - this is the Mail Merge Toolbar and it appears
whenever a Mail Merge Main document is the active document in Word 2000.
Each time you want to include information from your data source, insert a
"Merge field" - you can do this using the "Insert Merge Field" dropdown.
Word initially shows a merge field using two chevrons, roughly like this:

myfield

If you click the toolbar button that looks like this:


ABC

then you can preview what your merge will look like with data from your data
source. You can use the |, , and | buttons to preview different
records. But bewa in Word 2000 you can only merge to 2 different formats.
Either you can send each e-mail as plain text (i.e. Word strips all
formatting), or you can send each e-mail with just a subject and an
attachment containing a Word document (i.e. there is no body text in the
message).

8. If you want to filter your data, click the "Mail Merge Helper" icon on
the mailmerge toolbar - it is just after the | button, and select Query
Options...

9. When you are ready to merge (and I suggest you try this early on), save
your document (optional), click the Merge... button on the MailMerge
toolbar. Select "Electronic Mail" in the dropdown list (if it is greyed out,
then you will have to do some other stuff). Then click Setup. Select the
Excel column that contains the e-mail addresses you want to send to. Type a
subject line (it is the same for all the e-mails - you can't for example
select a field to use as the subject). Check or uncheck "Send document as an
attachment" as appropriate, then click OK.

And that's it, really. Graham Mayor has lots of useful stuff about Mailmerge
on his website at www.gmayor.com but when reading material on the web be
aware that it often describes Word 2003 which differs in several ways (the
general idea is identical, but there are all sorts of differences in the
User Interface and other areas).

If "Electronic Mail" is greyed out in step 8,
1. Go into Internet Explorer, Tools|Internet Options|Programs and ensure
the correct program is set up in "E-mail" (and probably "Contact list" as
well, although you can't use Outlook Express directly as a source of e-mail
addresses for merge)
2. close Word, re-open and try again.
3. if the option is still not available, make sure you have sent at least
one e-mail. Then try again. If it still doesn't work, close Word and your
e-mailer, open your Windows folder, make a backup copy of WIN.INI, then
open WIN.INI in Notepad, and ensure that it contains the following lines:

[Mail]
MAPI=1
CMC=1
CMCDLLName=mapi.dll
CMCDLLNAME32=mapi32.dll
MAPIX=1
MAPIXVER=1.0.0.1
OLEMessaging=1

Then re-open Word and try again.

Peter Jamieson


wrote in message
oups.com...
The sofware im using is all office 2000

I have a Excel file with email address and various other pieces of
information ie name.
I want to merge these into various emails, one to each address with
different information inside.
I cannot work out how to do this, does anyone know of a good guide? Or
can you give me some ideas to play around with.

The end product will be 190 emails to seperate addresses with different
information but the same letter in each. I can create the letters but
dont want to have to type out the 190 email addresses!

Cheers in advance for any help...

Cal

[Sanjay Singh]

You could use a product such as eMailMerge 4Outlook.
http://www.addins4outlook.com/emailmerge/default.asp

Import contacts from Excel into a Contacts folder first.


Regards
Sanjay Singh
---------------------------------------------
Gain Time by Making Outlook do the Work
http://www.Addins4Outlook.Com
---------------------------------------------

wrote in message
oups.com...
The sofware im using is all office 2000

I have a Excel file with email address and various other pieces of
information ie name.
I want to merge these into various emails, one to each address with
different information inside.
I cannot work out how to do this, does anyone know of a good guide? Or
can you give me some ideas to play around with.

The end product will be 190 emails to seperate addresses with different
information but the same letter in each. I can create the letters but
dont want to have to type out the 190 email addresses!

Cheers in advance for any help...

Cal

[[email protected]]

Thankyou very much this worked perfectly. Im sending the emails in
plain text (not as an attached word document), do you know if there is
a way to attach another word document to this email aswell? If not dont
worry this is not essential.

Thanks again.

Callum

[Peter Jamieson]

See Doug Robbins' article at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

Peter Jamieson

wrote in message
ups.com...
Thankyou very much this worked perfectly. Im sending the emails in
plain text (not as an attached word document), do you know if there is
a way to attach another word document to this email aswell? If not dont
worry this is not essential.

Thanks again.

Callum