Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2008

Tip: Looking for answers? Try searching our database.

Mail Merge with Attachement Fail

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PS - 09 Mar 2006 02:38 GMT
I've taken Doug's advice and prepared the mail merge with attachment and sent
via email.  However, only the very first one received the main body (text) in
html.  For the second and third receiptants, they can only receive the
attachments, but not the text itself.  Do you have a clue?

The outlook I use is Outlook 2003 and Word is 2002.

Thanks.
Doug Robbins - Word MVP - 09 Mar 2006 04:47 GMT
It sounds like you have not executed the mailmerge that contains the body
text to a new document and had that document as the active document when you
ran the macro.

Signature

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

> I've taken Doug's advice and prepared the mail merge with attachment and
> sent
[quoted text clipped - 6 lines]
>
> Thanks.
PS - 09 Mar 2006 16:50 GMT
Oh, yes.  I missed the important point that I must merge to a new document
before I ran the macro.

This macro really help a lot.  Many thanks.

PS.

> It sounds like you have not executed the mailmerge that contains the body
> text to a new document and had that document as the active document when you
[quoted text clipped - 10 lines]
> >
> > Thanks.
PS - 10 Mar 2006 01:44 GMT
Any chance I can put someone in the cc list for the mail merged email?  And
how??

> Oh, yes.  I missed the important point that I must merge to a new document
> before I ran the macro.
[quoted text clipped - 17 lines]
> > >
> > > Thanks.
Doug Robbins - Word MVP - 10 Mar 2006 19:25 GMT
Having set the reference to the Outlook Object Library, you can make use of
any of the methods included in that library.  Included in them are methods
to CC and BCC.  You will need to determine how you want to provide the email
addresses for the cc recipients.  You could have them included in the
catalog or directory merge document and grab them from there in the same way
that the email address of the addressee is obtained from that file, or you
could use an input box to enter it, or you can hardcode it into the macro.

The following modified section of the code shows how it would be done if it
is hardcoded:

   With oItem
       .Subject = mysubject
       .Body = ActiveDocument.Content
       Set Datarange = Maillist.Tables(1).Cell(Counter, 1).Range
       Datarange.End = Datarange.End - 1
       .To = Datarange
       .CC = "someoneelse@somewhere.com"
       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
       .Send
   End With

If you were to put the email address for the cc in the second column of the
catalog or directory merge document, then you would need to change

       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

to

       For i = 3 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

so that the macro starts looking for the attachments in the third column
rather than the second.
Signature

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

> Any chance I can put someone in the cc list for the mail merged email?
> And
[quoted text clipped - 27 lines]
>> > >
>> > > Thanks.
PS - 11 Mar 2006 05:25 GMT
I've tried to add the .CC code in the macros.  But then, when I ran the
macros, the "click-yes" message pump up as ususal, but the mail never
delivered.  Not sure which step i missed, will try again.

PS.

> Having set the reference to the Outlook Object Library, you can make use of
> any of the methods included in that library.  Included in them are methods
[quoted text clipped - 72 lines]
> >> > >
> >> > > Thanks.
manne142 - 27 Mar 2008 14:48 GMT
Hi, i'm trying do do what you suggest, executing a new mailmerge and running
the macro from the mailmerge result window. I still get mails with the body
text and attachement in only the first mail and only the attachement in the
rest. I'm using office 2007.
Signature

--manne142--

> It sounds like you have not executed the mailmerge that contains the body
> text to a new document and had that document as the active document when you
[quoted text clipped - 10 lines]
> >
> > Thanks.
Doug Robbins - Word MVP - 27 Mar 2008 20:52 GMT
How many Sections are there in the document in the mailmerge result window?

Signature

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

> Hi, i'm trying do do what you suggest, executing a new mailmerge and
> running
[quoted text clipped - 21 lines]
>> >
>> > Thanks.
manne142 - 28 Mar 2008 08:26 GMT
Hi, I found the solution myself. It worked out well when i did not use the
wizard, but clicked the buttons on the merge tool bar. When I finally clicked
the fulfill-button (I'm not sure what it is called in english, I'm using the
norwegian version of Office), and then ran the macro, it worked out fine.
The "MailMerge with attachements"-function should really be a default option
in MS Office. But that is probably out of your hands....
Thanks for your help, your macro really helped us.
Signature

--manne142--

> How many Sections are there in the document in the mailmerge result window?
>
[quoted text clipped - 23 lines]
> >> >
> >> > Thanks.
Doug Robbins - Word MVP - 28 Mar 2008 10:13 GMT
Glad you got it sorted out.  The Wizard is a bit more like a Magician -
Designed to deceive.

The English for "fulfill" in this context would be "execute".

Signature

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

> Hi, I found the solution myself. It worked out well when i did not use the
> wizard, but clicked the buttons on the merge tool bar. When I finally
[quoted text clipped - 38 lines]
>> >> >
>> >> > Thanks.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.