Inserting email addresses into the To:, Cc: fields ets using macros

  • Thread starter Thread starter Phillip Topping
  • Start date Start date
P

Phillip Topping

In the course of my daily duties at work I have to send several emails
every day which have files attached to them.

I wish to know how to create a macro to automatically insert a list of
recipients in the address fields so I can just click a button each time
rather than retyping them again and again (or going back to previous
sent emails and copying/pasting.

Bear in mind that the email has already been created by the File....Send
to recipient as attachment option from Excel.

Any help greatly appreciated.

Regards,
Phillip
 
I'm not familier with creating a file-send to in Excel, but it would seem to
me that if you created a "group" in your address book that included all of
the individuals you want to send to, that should solve the problem.

Addressbook : File : New Distribution List
 
Yes that would probably work but I would still like to know how to use
the olTo: OlCc: fields etc in Visual Basic. Outlook seems to be a
different proposition to writing code in Excel or Word or Access and I
am having trouble with even the simplest macros in Outlook.
 
Back
Top