It's probably worth going through Doug's method step by step as it's a good
general-purpose method which I  know he uses (or perhaps used) a lot,
whereas the following macros are nothing like as well tested (well, in fact
the versions I've posted here havne't been tested at all). If it's the
macros themselves that make it hard to follow, that's a problem as I don't
think you can do this without them.

If you are merging to Outlook (not Outlook Express) you may be able to do
something slightly simpler using a VBA macro to do "one merge per data
source record" - i.e. this won't work for more complex merges where you have
{ NEXT }, { NEXTIF } and probably { SKIP } or { SKIPIF } fields.

You need to put your list of CC addresses into a column in Excel where each
address except perhaps the last is terminated by a semi-colon ";". Let's say
this field is called "CC"

e.g. address1@url1.xxx; address2@url2.xxx

Personally I would suggest that you stick to using a plain text body, for
which you can try something based on the following VBA. You will need to use
Word VB Editor's Tools|References option to add the Outlook Library as a
reference (if Macros are really unfamiliar, see e.g.

http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm
)

Sub EmailOneDocPerSourceRecWithBody()
Dim bOutlookStarted As Boolean
Dim bTerminateMerge As Boolean
Dim intSourceRecord As Integer
Dim objMailItem As Outlook.MailItem
Dim objMerge As Word.MailMerge
Dim objOutlook As Outlook.Application
Dim strMailCC As String
Dim strMailSubject As String
Dim strMailTo As String
Dim strMailBody As String
Dim strOutputDocumentName As String

bOutlookStarted = False
bTerminateMerge = False

' Set up a reference to the
' Activedocument, partly because
' the ActiveDocument changes as you
' merge each record

Set objMerge = ActiveDocument.MailMerge

' Start Outlook as necessary

On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If Err <> 0 Then
 Set objOutlook = CreateObject("Outlook.Application")
 bOutlookStarted = True
End If

With objMerge

' If no data source has been defined,
' do it here using OpenDataSource.
' But if it is already defined in the
' document, you should not need to
' define it here.

' .OpenDataSource _
' Name:="whatever"

intSourceRecord = 1

Do Until bTerminateMerge
 .DataSource.ActiveRecord = intSourceRecord

 ' if we have gone past the end
 ' (and possibly, if there are no records)
 ' then the Activerecord will not be what
 ' we have just tried to set it to

 If .DataSource.ActiveRecord <> intSourceRecord Then
   bTerminateMerge = True
   ' the record exists
 Else

   ' while we are looking at the
   ' correct activerecord,
   ' create the mail subject, body, "to" and "cc"
   ' Just some sample code here - replace it with
   ' whatever you need. But ensure that the field names
   ' match the ones in your data source exactly - uppercase/lowercase
   ' differences are significant here

   strMailSubject = _
     "Results for " & _
     objMerge.DataSource.DataFields("Firstname") & _
     " " & objMerge.DataSource.DataFields("Lastname")
   strMailBody = _
     "Dear " & objMerge.DataSource.DataFields("Firstname") & _
     vbCrLf & _
     "Please find attached a Word document containing" & vbCrLf & _
     "your results for..." & vbCrLf & _
     vbCrLf & _
     "Yours" & vbCrLf & _
     "Your name"
   strMailTo = objMerge.DataSource.DataFields("Emailaddress")
   strMailCC = objMerge.DataSource.DataFields("CC")

   ' create the document path name
   ' In this case it can be the same for every recipient,
   ' but if you want to retain copies of the
   ' document, you can use info. in the data source

   ' this is an example - insert your
   ' own pathname here

   strOutputDocumentName = "c:\a\results.doc"

   ' strOutputDocumentName = _
   '  "c:\mymergeletters\_" & _
   '  .DataSource.DataFields("Lastname").Value & _
   '  " letter.doc"
   .DataSource.FirstRecord = intSourceRecord
   .DataSource.LastRecord = intSourceRecord
   .Destination = wdSendToNewDocument
   .Execute

   ' The Activedocument is always the
   ' output document

   ' Add any parameters you need to these calls
   ActiveDocument.SaveAs strOutputDocumentName
   ActiveDocument.Close

   ' Now create a mail item

   Set objMailItem = objOutlook.CreateItem(olMailItem)
   With objMailItem
     .Subject = strMailSubject
     .Body = strMailBody
     .To = strMailTo
     .CC = strMailCC
     .Attachments.Add strOutputDocumentName, olByValue, 1
     '.Save
     .Send
    End With
    Set objMailItem = Nothing

   intSourceRecord = intSourceRecord + 1
 End If
Loop
End With

' Close Outlook if appropriate

If bOutlookStarted Then
 objOutlook.Quit
End If

Set objOutlook = Nothing
Set objMerge = Nothing

End Sub

However, if you need an HTML body, try starting with (the rather similar)

Sub EmailOneHTMLPagePerSourceRecWithBody()
' By Peter Jamieson, 2006
Dim bOutlookStarted As Boolean
Dim bTerminateMerge As Boolean
Dim intSourceRecord As Integer
Dim objMailItem As Outlook.MailItem
Dim objMerge As Word.MailMerge
Dim objOutlook As Outlook.Application
Dim strMailCC As String
Dim strMailSubject As String
Dim strMailTo As String
Dim strMailBody As String
Dim strOutputDocumentName As String

bOutlookStarted = False
bTerminateMerge = False

' Set up a reference to the
' Activedocument, partly because
' the ActiveDocument changes as you
' merge each record

Set objMerge = ActiveDocument.MailMerge

' Start Outlook as necessary

On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If Err <> 0 Then
 Set objOutlook = CreateObject("Outlook.Application")
 bOutlookStarted = True
End If

With objMerge

' If no data source has been defined,
' do it here using OpenDataSource.
' But if it is already defined in the
' document, you should not need to
' define it here.

' .OpenDataSource _
' Name:="whatever"

intSourceRecord = 1

Do Until bTerminateMerge
 .DataSource.ActiveRecord = intSourceRecord

 ' if we have gone past the end
 ' (and possibly, if there are no records)
 ' then the Activerecord will not be what
 ' we have just tried to set it to

 If .DataSource.ActiveRecord <> intSourceRecord Then
   bTerminateMerge = True
   ' the record exists
 Else

   ' while we are looking at the
   ' correct activerecord,
   ' create the mail subject, body, "to" and "cc"
   ' Just some sample code here - replace it with
   ' whatever you need. But ensure that the field names
   ' match the ones in your data source exactly - uppercase/lowercase
   ' differences are significant here

   strMailSubject = _
     "Results for " & _
     objMerge.DataSource.DataFields("Firstname") & _
     " " & objMerge.DataSource.DataFields("Lastname")

   ' Use a simple sample
   strMailBody = "<HTML><BODY><TABLE
BORDER=5><TR><TD>k</TD><TD>t</TD></TR></TABLE></BODY></HTML>"
   strMailTo = objMerge.DataSource.DataFields("Emailaddress")
   strMailCC = objMerge.DataSource.DataFields("CC")

   ' create the document path name
   ' In this case it can be the same for every recipient,
   ' but if you want to retain copies of the
   ' document, you can use info. in the data source

   ' this is an example - insert your
   ' own pathname here

   strOutputDocumentName = "c:\a\results.htm"

   ' strOutputDocumentName = _
   '  "c:\mymergeletters\_" & _
   '  .DataSource.DataFields("Lastname").Value & _
   '  " letter.doc"
   .DataSource.FirstRecord = intSourceRecord
   .DataSource.LastRecord = intSourceRecord
   .Destination = wdSendToNewDocument
   .Execute

   ' The Activedocument is always the
   ' output document

   ' Add any parameters you need to these calls
   ActiveDocument.SaveAs strOutputDocumentName, wdFormatFilteredHTML
   ActiveDocument.Close

   ' Now create a new Mail Item

   Set objMailItem = objOutlook.CreateItem(olMailItem)
   With objMailItem
     .BodyFormat = olFormatHTML
     .Subject = strMailSubject
     .HTMLBody = strMailBody
     .To = strMailTo
     .CC = strMailCC
     .Attachments.Add strOutputDocumentName, olByValue, 1
     .Save
     .Send
    End With
    Set objMailItem = Nothing

   intSourceRecord = intSourceRecord + 1
 End If
Loop
End With

' Close Outlook if appropriate

If bOutlookStarted Then
 objOutlook.Quit
End If

Set objOutlook = Nothing
Set objMerge = Nothing

End Sub