Attaching different Excel files to emailed mail merge using merge.

[Pete Cuff]

Hi all,

Here's the problem...

I wish to email out 100 different accounts spreadsheets (Excel) to 100
different Treasurers by email. Mail Merge is the obvious answer. I have
been using the command 'includetext', where the file it links to has a merge
field in it to pick out the particular Excel file each Treasurer needs to
receive; for example
{ INCLUDETEXT "C:\\Accounts\\<FILENAME.xls>" }

This worked well on Office 2000, but since upgrading to Office 2003, when I
try to run this command, Word tries to convert the Excel file to a format it
can understand, which comes out as gibberish as it is trying to covert
everything to text rather than keep its Excel format.

If anyone can help with this difficult problem, I - and my 100 Treasurers -
would greatly appreciate it,.

 

[Doug Robbins - Word MVP]

I am not sure that would have worked in Word 2000 either, but you can send
out the spreadsheets as attachments by following the procedure in the
article "Mail Merge to E-mail with Attachments" at:

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

--
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