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 2004

Tip: Looking for answers? Try searching our database.

How do I add a cc: field to email-merge?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe Donohue - 18 Jan 2004 02:41 GMT
I send email notes to 60-odd clubs, each of which has a
president and secretary.

Is there any way I can add a "cc:" field to the email
merge?
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Jan 2004 09:22 GMT
Hi Joe,

You can't do it with mailmerge by itself.  However, you could do it by
modifying the procedure in the article "Mail Merge to E-mail with
Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

>I send email notes to 60-odd clubs, each of which has a
> president and secretary.
>
> Is there any way I can add a "cc:" field to the email
> merge?
Joe Donohue - 18 Jan 2004 14:16 GMT
Thanks for the tip Doug. I wil have to mull the article
over to see how I can use it to send a customized note to
both people, but I'll work on it.

Thanks again
Joe Donohue
>-----Original Message-----
>Hi Joe,
[quoted text clipped - 12 lines]
>
>.
kanfoosh - 04 Mar 2004 18:49 GMT
Any Luck with this Joe? - I have been unable to follow the instruction
provided above...

Shame..

Keena
Peter Jamieson - 05 Mar 2004 09:17 GMT
How far did you get and what went wrong?

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Any Luck with this Joe? - I have been unable to follow the instructions
> provided above...
[quoted text clipped - 5 lines]
> ------------------------------------------------
> ~~ Message posted from http://www.WordForums.com/
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 05 Mar 2004 09:30 GMT
In the following modification of the code, provision has been made for you
to entere the address for the cc:

Dim Source As Document, Maillist As Document
Dim Datarange As Range
Dim Counter As Integer, i As Integer
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
Dim mysubject As String, message As String, title As String

Set Source = ActiveDocument

' Check if Outlook is running.  If it is not, start Outlook

On Error Resume Next

Set oOutlookApp = GetObject(, "Outlook.Application")

If Err <> 0 Then
   Set oOutlookApp = CreateObject("Outlook.Application")
   bStarted = True
End If

' Open the catalog mailmerge document

With Dialogs(wdDialogFileOpen)
   .Show
End With

Set Maillist = ActiveDocument

' Show an input box asking the user for the subject to be inserted into the
Email messages

message = "Enter the subject to be used for each email message."    '
Setprompt.
title = " Email Subject Input"    ' Set title.

' Display message, title

mysubject = InputBox(message, title)

' Iterate through the rows of the catalog mailmerge document, extracting
theInformation
' to be included in each email.

Counter = 1
While Counter <= Maillist.Tables(1).Rows.Count
   Source.Sections.First.Range.Cut
   Documents.Add
   Selection.Paste
   Set oItem = oOutlookApp.CreateItem(olMailItem)
   With oItem
       .Subject = mysubject
       .Body = ActiveDocument.Content
       Set Datarange = Maillist.Tables(1).Cell(Counter, 1).Range
       Datarange.End = Datarange.End - 1
       .To = Datarange
       .CC = "" '[Enter email address to which the cc is to be sent.]
       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
   Set oItem = Nothing
   ActiveDocument.Close wdDoNotSaveChanges
   Counter = Counter + 1
Wend

'  Close Outlook if it was started by this macro.

If bStarted Then
   oOutlookApp.Quit
End If

?Clean up

Set oOutlookApp = Nothing
Source.Close wdDoNotSaveChanges

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>
> Any Luck with this Joe? - I have been unable to follow the instructions
[quoted text clipped - 6 lines]
> ------------------------------------------------
> ~~ Message posted from http://www.WordForums.com/
 
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.