Outlook From Field Macro

Thanks for the reply Sue,

When I try to run the Macro I am getting a 'Run-time '91' error: Object
variable or With block variable not set' any idea what this means?

I have the macro set out as

Sub Address()
Application.ActiveInspector.CurrentItem.From = "Email Address Here"
End Sub

Obviously I have the email address I want to go in the From Field in the
quotation marks.

Thanks for any continuing support.



"Sue Mosher [MVP]" wrote:

> For the message that's currently open:
>
> Application.ActiveInspector.CurrentItem.SentOnBehalfOfName = "unique
> name or address of mailbox"
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Karliki" <Karliki DeleteThis @discussions.microsoft.com> wrote in message
> news:B6F8FA73-DB50-4548-8A1C-E2CB432C2C3A@microsoft.com...
> > Hello,
> >
> > I am trying to create a macro that will automatically populate the 'From'
> > field in an outlook email.
> >
> > I send a lot of email to different departments and use oft. templates.
> > However, as I want the replies to go to the group inbox and not I personal
> > one I am finding that I have to manaually add the group email address into
> > every email I send.
> >
> > I have a very limited knowledge of Macro's (especially using them with
> > Outlook) so any help would be greatly appreciated.
> >
>
>
>

Do you have an item open? If not, there's no ActiveInspector.

Why are you using From, a property that doesn't exist on MailItem objects,
rather than the SentOnBehalfOfName property?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Karliki" <Karliki DeleteThis @discussions.microsoft.com> wrote in message
news:46596DC1-D63E-4FA3-BCDE-4E8D575A94A9@microsoft.com...
> Thanks for the reply Sue,
>
> When I try to run the Macro I am getting a 'Run-time '91' error: Object
> variable or With block variable not set' any idea what this means?
>
> I have the macro set out as
>
> Sub Address()
> Application.ActiveInspector.CurrentItem.From = "Email Address Here"
> End Sub
>
> Obviously I have the email address I want to go in the From Field in the
> quotation marks.
>
> Thanks for any continuing support.
>
>
>
> "Sue Mosher [MVP]" wrote:
>
>> For the message that's currently open:
>>
>> Application.ActiveInspector.CurrentItem.SentOnBehalfOfName = "unique
>> name or address of mailbox"

>>
>> "Karliki" <Karliki DeleteThis @discussions.microsoft.com> wrote in message
>> news:B6F8FA73-DB50-4548-8A1C-E2CB432C2C3A@microsoft.com...
>> > Hello,
>> >
>> > I am trying to create a macro that will automatically populate the
>> > 'From'
>> > field in an outlook email.
>> >
>> > I send a lot of email to different departments and use oft. templates.
>> > However, as I want the replies to go to the group inbox and not I
>> > personal
>> > one I am finding that I have to manaually add the group email address
>> > into
>> > every email I send.
>> >
>> > I have a very limited knowledge of Macro's (especially using them with
>> > Outlook) so any help would be greatly appreciated.

Sue,

Thanks for your help I managed this morning to get it working. The confusion
was due to my general ignorance in the field of Macro creation. Thanks again
for your help.



"Sue Mosher [MVP]" wrote:

> Do you have an item open? If not, there's no ActiveInspector.
>
> Why are you using From, a property that doesn't exist on MailItem objects,
> rather than the SentOnBehalfOfName property?
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>
>
> "Karliki" <Karliki.RemoveThis@discussions.microsoft.com> wrote in message
> news:46596DC1-D63E-4FA3-BCDE-4E8D575A94A9@microsoft.com...
> > Thanks for the reply Sue,
> >
> > When I try to run the Macro I am getting a 'Run-time '91' error: Object
> > variable or With block variable not set' any idea what this means?
> >
> > I have the macro set out as
> >
> > Sub Address()
> > Application.ActiveInspector.CurrentItem.From = "Email Address Here"
> > End Sub
> >
> > Obviously I have the email address I want to go in the From Field in the
> > quotation marks.
> >
> > Thanks for any continuing support.
> >
> >
> >
> > "Sue Mosher [MVP]" wrote:
> >
> >> For the message that's currently open:
> >>
> >> Application.ActiveInspector.CurrentItem.SentOnBehalfOfName = "unique
> >> name or address of mailbox"
>
> >>
> >> "Karliki" <Karliki.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:B6F8FA73-DB50-4548-8A1C-E2CB432C2C3A@microsoft.com...
> >> > Hello,
> >> >
> >> > I am trying to create a macro that will automatically populate the
> >> > 'From'
> >> > field in an outlook email.
> >> >
> >> > I send a lot of email to different departments and use oft. templates.
> >> > However, as I want the replies to go to the group inbox and not I
> >> > personal
> >> > one I am finding that I have to manaually add the group email address
> >> > into
> >> > every email I send.
> >> >
> >> > I have a very limited knowledge of Macro's (especially using them with
> >> > Outlook) so any help would be greatly appreciated.
>
>
>