View Single Post
  #1   Report Post  
Pete Cuff
 
Posts: n/a
Default Attaching different Excel files to emailed mail merge using merge.

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