If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining Like Records
Hi all. First post - I appreciate your patience
We are trying to send expense reports emails from a spreadsheet. The spreadsheet has data in cells similar to table shown below: Name | Expense | Details Joe 1 | $80 | Hotel Joe 1 | $40 | Cab Joe 2 | $60 | Hotel We would like to have the records combined into a single email if the "Name" field is idintical to the preceding. I found a nice how-to online: http://cornell.veplan.net/article.aspx?&a=3815 .. However he resulting documents shows the following error when we try to send the emails: "You cannot send a catalog created by merging documents directly to mail, fax or a printer". I can provide the formatting from the Mail Merge document if that would help. So - does anyone know a method for combining like records from a data source when creating mail merge emails? Thanks, Mike |
#2
|
|||
|
|||
Combining Like Records
You can't use Word's Catalogue/Directory Mailmerge facility directly for this (the terminolgy depends on the Word version). However,
to see how you can use it indirectly, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it. -- Cheers macropod [Microsoft MVP - Word] "Mike" wrote in message news Hi all. First post - I appreciate your patience We are trying to send expense reports emails from a spreadsheet. The spreadsheet has data in cells similar to table shown below: Name | Expense | Details Joe 1 | $80 | Hotel Joe 1 | $40 | Cab Joe 2 | $60 | Hotel We would like to have the records combined into a single email if the "Name" field is idintical to the preceding. I found a nice how-to online: http://cornell.veplan.net/article.aspx?&a=3815 . However he resulting documents shows the following error when we try to send the emails: "You cannot send a catalog created by merging documents directly to mail, fax or a printer". I can provide the formatting from the Mail Merge document if that would help. So - does anyone know a method for combining like records from a data source when creating mail merge emails? Thanks, Mike |
Thread Tools | |
Display Modes | |
|
|