<div>
Thank you so much. I just need to send a couple of the cells of information. Which part of your code specifies which mailbox to use. As my outlook has 3 different email accounts and I need to select an account which email should be sent from.
</div>


Thank you so much. I just need to send a couple of the cells of information. Which part of your code specifies which mailbox to use. As my outlook has 3 different email accounts and I need to select an account which email should be sent from.

<div>
See Ron De Bruin's explanation of SendUsingAccount at <a href="http://www.rondebruin.nl/win/s1/outlook/account.htm" rel="ugc">http://www.rondebruin.nl/win/s1/outlook/account.htm</a>
</div>


See Ron De Bruin's explanation of SendUsingAccount at http://www.rondebruin.nl/win/s1/outlook/account.htm [http://www.rondebruin.nl/win/s1/outlook/account.htm]

<div>
Can you attach a sample of your excel worksheet so I can rework the code to meet your needs?
</div>


Can you attach a sample of your excel worksheet so I can rework the code to meet your needs?

<div>
I don't need the attachment bit but I will work on changing that thank u very much.
</div>


I don't need the attachment bit but I will work on changing that thank u very much.

<div>
<div class="content wysiwyg-content">
I need to be able to send an email via excel using the contents of a worksheet to populate the email. Then I need to be able to select the outlook mailbox which I wish to send the email from which won't be the default for outlook.
</div>
</div>


I need to be able to send an email via excel using the contents of a worksheet to populate the email. Then I need to be able to select the outlook mailbox which I wish to send the email from which won't be the default for outlook.

Excel sending an email

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.