Emailing a directory in Word 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

divinite00@gmail.com - 22 Nov 2006 19:00 GMT

I am working on a project that contains the following information:

A list of School Districts
A list of Schools
Custom IDs for Principals, Teachers and Librarians

I would like to assemble an email to Superintendents at the district
level that contains the IDs for each of their districts schools. I
have succeeded in doing this in a directory format using conditional
formatting checking the "District" field.

This is fine for print output, however Word says it cannot output to
email from a directory format. I am unable to get this to work
properly for email output. When I try it says "You cannot send a
catalog created by merging documents directly to mail, fax, or a
printer."

Is there a way to send it indirectly or have the same type of output in
a different format? I have over 500 districts that need mailings and I
really would prefer to automate this task.

Reply to this Message

Doug Robbins - Word MVP - 23 Nov 2006 04:47 GMT

A new document is the only possible destination for a catalog type mail
merge.

You might be able to do something with the following:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at :

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Even then, you are going to need to use VBA to do the emailing. Much of the
code that you would need for that could be gleaned from the article "Mail
Merge to E-mail with Attachments" at

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am working on a project that contains the following information:
>
[quoted text clipped - 16 lines]
> a different format? I have over 500 districts that need mailings and I
> really would prefer to automate this task.

Reply to this Message