Re: Carbon Copies in Email Merge

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Doug Robbins (dkr_at_NOmvpsSPAM.org)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 19:08:08 -0400

I am not a programmer either and all that I know about visual basic has been
learned by reference to the Visual Basic Help file and trial and error.

At the beginning of the code you will need a

Dim myccrecipient as Recipient

and then in the code after the .To statement, you will need to insert

         Set myccrecipient = .Recipients.Add("CC Recipient")
         myccrecipient.Type = olCC

In place of "CC Recipient" you would place the email address of the party to
whom the CC is to be sent. 

-- 
Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
"fgwiii" <fgwiii@discussions.microsoft.com> wrote in message 
news:FEB0DD08-0C77-42C8-BA2A-FBCBFC8564D1@microsoft.com...
> While I am certainly willing to take a stab at this, can you give me a 
> little
> direction at this? I am not a programmer. Would you please be a little 
> more
> specific?
>
> Thanks
>
> Fred
>
> "Doug Robbins" wrote:
>
>> After declaring myccrecipient as Recipient, use the following in the code
>> after the .To statement
>>
>>         Set myccrecipient = .Recipients.Add("CC Recipient")
>>         myccrecipient.Type = olCC
>>
>> For more details, see the VB help file for CC  (you will need to have set
>> the reference to the Outlook Object library)
>>
>> -- 
>> Please respond to the Newsgroup for the benefit of others who may be
>> interested.   Questions sent directly to me will only be answered on a 
>> paid
>> consulting basis.
>>
>> Hope this helps,
>> Doug Robbins - Word MVP
>> "fgwiii" <fred.wildauer@covance.com> wrote in message
>> news:3baa01c4afb6$f92c1160$a401280a@phx.gbl...
>> >I have found several posts about including  carbon copies
>> > to multiple recipients, but I have been unable to find an
>> > relevant information in the MVP post:
>> >
>> > http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.ht
>> > m
>> >
>> > Would someone please give me a hand here?
>> >
>> > Thanks,  fgwiii
>> >
>>
>>
>>

Relevant Pages

  • RE: SendObject (send an unique query to each of a list of recipien
    ... Problem could be that you may need to set up a reference to the DAO object ... So if your query name is: ... eMail subject is: Data from Alison ... (data to be sent to the recipient). ...
    (microsoft.public.access.modulesdaovba)
  • Re: Controlling Outlook 2003 with excel
    ... ' requires a reference to the Microsoft Outlook 8.0 Object Library ... Set olMailItem = OLF.Items.Add ' creates a new e-mail message ...
    (microsoft.public.excel.programming)
  • Re: Cohens paper on byte order
    ... (I am not aware of any reference supporting that.) ... Now a recipient with an arbitrary different ... (This conversion work can of course also be done by ... Adopt a common convention, e.g. employing ...
    (sci.crypt)
  • Re: "Limit number of recipients per message to" - Help file inconsiste
    ... i think you're confusing two limits...look at the help file for "recipient ... Susan Conkey [MVP] ... a Messages tab on which is a setting named "Limit number of recipients per ...
    (microsoft.public.exchange.admin)
  • RE: SendObject (send an unique query to each of a list of recipients)
    ... Sorry - forgot to poit out that you have to create a reference to the ... outlook object model - in the Access VBA IDE go to Tools references and then ... Each recipient must have have thier attachment, ... Table A. I need the query that filters by the same unique identifier as the ...
    (microsoft.public.access.modulesdaovba)