Dear all,
My question is how to put the Email Address(by manual input) in Excel into the "TO" field in Microsoft Outlook ?
For instance, I have an email address in a worksheet, Company name on column A and Email Address on column B. And I also have a number of worksheets in the same file named by the Company name.
I 've tried the routingslip function that each worksheets can be e-mailed through Microsoft outlook, but I have to type in the Email address at Outlook first.

Is there any method that I can type the Email address of the company in Excel and automatically put the email address on the "TO" field in Outlook, not using the address book of Outlook?

Thanks for help in advance
Best Regards,
Terry