Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Attachments and CC
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Attachments and CC
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 -- 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 "nrk3" wrote in message oups.com... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Attachments and CC
Thanks Doug,
For the help but is there anyway to populate the CC field dynamically also? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Attachments and CC
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. -- 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 "nrk3" wrote in message oups.com... Thanks Doug, For the help but is there anyway to populate the CC field dynamically also? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Include a message in e-mails with attachments? | Mailmerge | |||
Attachments Don't Open in Word From A Certain Sender | Microsoft Word Help | |||
How do I get mail attachments listed on header/toolbar in Word | Microsoft Word Help | |||
Opening Word attachments | Microsoft Word Help | |||
Word Attachments open multiple copies of Word | Microsoft Word Help |