<div>
I had tried that but when the email was displayed the From box was blank so I assumed it didn't work. &nbsp;However, after your reply I tried sending it and low and behold it worked.<br />
<br />
Thanks for your help.
</div>


I had tried that but when the email was displayed the From box was blank so I assumed it didn't work.  However, after your reply I tried sending it and low and behold it worked.

Thanks for your help.

<div>
I think you use the .SenderEmailAddress property of the mail object.<br />
<br />
So:-<br />
<br />
obj.SenderEmailAddress = &quot;someone@example.com&quot;
</div>


I think you use the .SenderEmailAddress property of the mail object.

So:-

obj.SenderEmailAddress = "someone@example.com"

<div>
SenderEmailAddress is a read-only property. &nbsp;But its fine, as long as it goes from the right address I'm good.<br />

</div>


SenderEmailAddress is a read-only property.  But its fine, as long as it goes from the right address I'm good.


<div>
<div class="content wysiwyg-content">
I have written some VBA code to send an email from Excel 2007 using Outlook.Application and Outlook.MailItem. &nbsp;My outlook is set up to access my exchange account but I have Send As permission to send from another account. &nbsp;<br />
<br />
Can anyone tell me how to change the From field to the Send As address using VBA.<br />
<br />
Thanks<br />

</div>
</div>


I have written some VBA code to send an email from Excel 2007 using Outlook.Application and Outlook.MailItem.  My outlook is set up to access my exchange account but I have Send As permission to send from another account.  

Can anyone tell me how to change the From field to the Send As address using VBA.

Thanks


How do I change the FROM address in Outlook 2007 using VBA

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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