Mail Merge Option

[Akash]

Hi,

Can anyone help me in this. If i get any solution it would be of
greathelp.

How to send Copy of a mail to a specific id while using Mail Merge?
E.g. Mail Merge gives you a facility to send mails to respective
individual person to whose Email id u have selected , what if i want
that whatever mail I send using mail merge, a copy of individual copy
should go to my boss email id.

Rgrds

Akash

 

[Graham Mayor]

A simple way at extra cost would be to use MAPILab's Mailmerge toolkit
add-in for Outlook http://www.mapilab.com/outlook/mail_merge/
which requires no user programming.

Otherwise you could modify the macro in the article prepared by fellow MVP
Doug Robbins at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

eg in the following section where indicated add the line as shown,
substituting the boss's email address. This will send him a blind CC (ie the
main recipient will not see who else you have sent it to). If you want to
send an open CC then remove the 'B' from BCC

With oItem
.Subject = mysubject
.Body = Source.Sections(j).Range.Text
'******************************
'add the line
.BCC = "(e-mail address removed)"
'******************************
Set Datarange = Maillist.Tables(1).Cell(j, 1).Range
Datarange.End = Datarange.End - 1
.To = Datarange
For i = 2 To Maillist.Tables(1).Columns.Count
Set Datarange = Maillist.Tables(1).Cell(j, i).Range
Datarange.End = Datarange.End - 1
.Attachments.Add Trim(Datarange.Text), olByValue, 1
Next i
.Send
End With

http://www.gmayor.com/installing_macro.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>