Attachments and CC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nrk3 - 07 Jun 2006 00:54 GMT

Hi everyone,

I was wondering if there is anyway to add attachments and do CC in mail
merge. I was able to run the script that does the attachments form
this group but I have not seen anything that could do both.

Thanks for any help.

Reply to this Message

Doug Robbins - Word MVP - 07 Jun 2006 04:51 GMT

Add either a .CC = or .BCC = in the code as shown below:

With oItem
.Subject = mysubject
.body = ActiveDocument.Content
Set Datarange = Maillist.Tables(1).Cell(Counter, 1).Range
Datarange.End = Datarange.End - 1
.To = Datarange
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
.CC = "email address for CC"
.BCC = "email address for BCC
.Send
End With

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 everyone,
>
[quoted text clipped - 3 lines]
>
> Thanks for any help.

Reply to this Message

nrk3 - 07 Jun 2006 22:22 GMT

Thanks Doug,

For the help but is there anyway to populate the CC field dynamically
also?

Reply to this Message

Doug Robbins - Word MVP - 08 Jun 2006 04:44 GMT

If you have the CC email addresses in the data source, you can include them
in the catalog or directory type mailmerge document that is used as part of
the procedure and get them from there using similar techniques to the way in
which the address of the addressee is obtained.

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

> Thanks Doug,
>
> For the help but is there anyway to populate the CC field dynamically
> also?

Reply to this Message