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

[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

 

[Jan Groshan]

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

 

[Phillip Topping]

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.