View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default EMAIL MERGE WITH 2 or + ATTACHMENTS

I can assure you that if you do it correctly, it will handle any number of
attachments.

This section of the code:

For i = 2 To Maillist.Tables(1).Columns.Count
Set Datarange = Maillist.Tables(1).Cell(Counter, i).Range
Datarange.End = Datarange.End - 1
.Attachments.Add Trim(Datarange.Text), olByValue, 1
Next i

Gets the information about each attachment from the second and any following
columns of the document created by exceuting the catalog mail merge.

Most probably reason for missing attachments are errors in the path\filename
in that catalog document. The slightest error is all that it will take e.g.
two spaces where there should only be one in a folder or filename.
--
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

"thomas79" wrote in message
...
Hi I tried this tutorial:

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

and it works but it sends only the attachment in the third column
(attachment2) while the attachment1 no.
How can I fix it? I need to send 2 attachments.. I tried to use 4 columns
but it always just send the attachment in the last one...

Thank you