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.

"Doug Robbins - Word MVP" wrote:

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 = "
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.
--
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

"PS" wrote in message
...
Any chance I can put someone in the cc list for the mail merged email?
And
how??


"PS" wrote:

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.

"Doug Robbins - Word MVP" wrote:

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.

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

"PS" wrote in message
...
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.