[Aisle2]

Hey guys,

I need to create an *email* mail-merge that has "a list sorted by category" (see this link: http://support.microsoft.com/kb/294686/). I know how to do the two individually, but I can't do them together because the above link/tutorial makes you do a "Directory" type of mail-merge rather than an "email" type mail-merge, and thus spits the result out as word docs (without allowing you to specify "To:", "Subject", etc.). I've also tried using the exact same code in an email mail-merge but it still separates them.

I'm using Word '07 and Windows XP. Thanks in advance for any help.

Take care,
Colin

 

[Aisle2]

Anyone have any ideas?

 

[macropod]

Hi Aisle2,

You can indeed use Word's Catalogue/Directory Mailmerge facility for category merges to email. To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://lounge.windowssecrets.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.

 

[Aisle2]

Thanks Macropad. That answers my quesiton. From the same site you referenced, I came across an add in that was created which helped simplify the process: http://www.gmayor.com/ManyToOne.htm

Take care,
Colin