Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA. Check out our site for more information about Excel VBA tutorials. Excel macros and usage notes to help beginners and fairly advanced users work with Excel spreadsheets. David McRitchie over 200 Excel web pages. C Create Excel file from DataTable without using Excel Object. Other Contents Design Chart Templates for Microsoft Excel Automatically update hundreds of PowerPoint slides from Excel in minutes Quickly and easily generate. This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more. Occasionally a client asks me to create a shared workbook in Excel, so two or more employees can work in it at the same time. It sounds good in theory, but I always. Ive taken code from a Word macro and combined it with some other VBA code to open a Word document and find and replace text based on user input. The code looks. Mail. Item. Send. Using. Account Property OutlookReturns or sets an Account object that represents the account under which the Mail. Item is to be sent. Readwrite. Syntaxexpression. Send. Using. Accountexpression An expression that returns a Mail. Item object. The Send. Using. Account property can be used to specify the account that should be used to send the Mail. Item when the Send method is called. This property returns Null Nothing in Visual Basic if the account specified for the Mail. KssaoW8/maxresdefault.jpg' alt='Vba Word Table Of Contents Update Internet' title='Vba Word Table Of Contents Update Internet' />Item no longer exists. Example. The following code sample in Microsoft Visual Basic for Applications enumerates the Accounts collection to find a Pop. If the account is found, then a message is created programmatically and the Send. Using. Account property is assigned to the Pop. Note that you must assign the Send. Using. Account property before you call the Send method. Sub Send. Using. Account. Dim o. Account As Outlook. For Each o. Account In Application. Session. Accounts. If o. Account. Account. Type ol. Pop. 3 Then. Dim o. Mail As Outlook. Mail. Item. Set o. Mail Application. Create. Itemol. Mail. Item. o. Mail. Subject Sent using POP3 Account. Mail. Recipients. Add someoneexample. Mail. Recipients. Resolve. All. o. Mail. Dental Slice Converter. Send. Using. Account o. Ellis Elementary Sunnyvale After School Program there. Account. See also. Concepts. Mail. Item Object. Other resources. Send an E mail Given the SMTP Address of an Account.