Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
thomas79 thomas79 is offline
external usenet poster
 
Posts: 2
Default EMAIL MERGE WITH 2 or + ATTACHMENTS

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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
thomas79 thomas79 is offline
external usenet poster
 
Posts: 2
Default EMAIL MERGE WITH 2 or + ATTACHMENTS

Thank you fro your reply.
Unluckily the problem is not the path, I wrote it correct, if I switch the
paths the result si that it sends only the file in the last column (that
before was in the second and was unsent).
I tried to send only one file ( only 1 column for the attachment) and it
works but if I add others it send only the file in the last. I don't
understand why.


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

Nor do I understand why. I can assure you though I use the routine
regularly to send multiple attachments, sometimes as many as 10 or 12 and
the only time it does not work is if I MADE A MISTAKE IN ENTERING THE PATH
OR FILENAME.in the datasource from which the directory merge is created.



--
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
...
Thank you fro your reply.
Unluckily the problem is not the path, I wrote it correct, if I switch the
paths the result si that it sends only the file in the last column (that
before was in the second and was unsent).
I tried to send only one file ( only 1 column for the attachment) and it
works but if I add others it send only the file in the last. I don't
understand why.




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
email merge and attachments Goffin Mailmerge 3 March 13th 07 08:07 AM
Email Merge with attachments problem Sam Mailmerge 2 January 18th 07 05:49 AM
Can I add different attachments for each email merge recipient? HeadFish Mailmerge 1 March 29th 06 04:57 AM
mail merge for email with attachments bwilli Mailmerge 3 March 20th 06 10:01 PM
Add Attachments to email merge from Word puntilla Mailmerge 2 June 15th 05 12:20 AM


All times are GMT +1. The time now is 03:57 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"