Incorporating user details from AD into an Outlook Form

Status
Not open for further replies.
N

ngreen

Hi.

We have a client who has passed us a form they use for corporate emails.

Alongside the usual signature details (name, address, phone nos, email

address), there is a panel with their "offer" of the month, which they change

monthly.

Below the signature, is a standard legal disclaimer.

At the bottom, there is a coloured panel containing the business address and

contact details.

What they would like us to do, is adapt the form so that the user details

are extracted from Active Directory, so that everyone's email footers look

the same.

The .oft file we have been passed from the client as an example, is dynamic

in relation to resizing the email window.

We have found a VBScript online (from Spiceworks), that extracts user

details from AD and puts them into a Word file and then adds it into the

signature area of Outlook. This is meant to go in to users' logon scripts.

Adapting .oft details to go into a signature in this manner looks very

tricky indeed!

The questions boil down to: Is this a viable thing at all ? Is the .oft file

the best method ? If not, is there a better one ?

I hope my explanation of the problem makes sense. If not, I can try and

clarify.

Thanks!

Nick.
 
If you have a script to get AD details and modify a Word document, the same

techniques could be used with the Outlook object model to modify an Outlook

message (i.e. one created from an .oft file that just lacks the signature)

and save it as an .oft file.

Whether an .oft file is a good solution depends on exactly what you mean by

"corporate emails" and the Outlook version. I would never use an .oft file

like the one you describe for anything other than occasional boilerplate

mailings.

Sue Mosher

"ngreen" <ngreen> wrote in message

news:0BF65A91-2B70-49C7-B795-5CDF7167EEB4@microsoft.com...
> Hi.

> We have a client who has passed us a form they use for corporate emails.
> Alongside the usual signature details (name, address, phone nos, email
> address), there is a panel with their "offer" of the month, which they
> change
> monthly.

> Below the signature, is a standard legal disclaimer.

> At the bottom, there is a coloured panel containing the business address
> and
> contact details.

> What they would like us to do, is adapt the form so that the user details
> are extracted from Active Directory, so that everyone's email footers look
> the same.

> The .oft file we have been passed from the client as an example, is
> dynamic
> in relation to resizing the email window.

> We have found a VBScript online (from Spiceworks), that extracts user
> details from AD and puts them into a Word file and then adds it into the
> signature area of Outlook. This is meant to go in to users' logon scripts.

> Adapting .oft details to go into a signature in this manner looks very
> tricky indeed!

> The questions boil down to: Is this a viable thing at all ? Is the .oft
> file
> the best method ? If not, is there a better one ?

> I hope my explanation of the problem makes sense. If not, I can try and
> clarify.

> Thanks!

> Nick.
 
Sorry, should have said that this is in Outlook 2007

"ngreen" wrote:


> Hi.

> We have a client who has passed us a form they use for corporate emails.
> Alongside the usual signature details (name, address, phone nos, email
> address), there is a panel with their "offer" of the month, which they change
> monthly.

> Below the signature, is a standard legal disclaimer.

> At the bottom, there is a coloured panel containing the business address and
> contact details.

> What they would like us to do, is adapt the form so that the user details
> are extracted from Active Directory, so that everyone's email footers look
> the same.

> The .oft file we have been passed from the client as an example, is dynamic
> in relation to resizing the email window.

> We have found a VBScript online (from Spiceworks), that extracts user
> details from AD and puts them into a Word file and then adds it into the
> signature area of Outlook. This is meant to go in to users' logon scripts.

> Adapting .oft details to go into a signature in this manner looks very
> tricky indeed!

> The questions boil down to: Is this a viable thing at all ? Is the .oft file
> the best method ? If not, is there a better one ?

> I hope my explanation of the problem makes sense. If not, I can try and
> clarify.

> Thanks!

> Nick.
 
Sue,

Thanks for your thoughts. I'll hunt down outlook object model details.

This is intended as a signature to be appended to all outgoing emails. What

would you recommend in preference to a .oft form ?

Thanks,

Nick.

"Sue Mosher [MVP]" wrote:


> If you have a script to get AD details and modify a Word document, the same
> techniques could be used with the Outlook object model to modify an Outlook
> message (i.e. one created from an .oft file that just lacks the signature)
> and save it as an .oft file.

> Whether an .oft file is a good solution depends on exactly what you mean by
> "corporate emails" and the Outlook version. I would never use an .oft file
> like the one you describe for anything other than occasional boilerplate
> mailings.
> > Sue Mosher
> > >

> "ngreen" <ngreen> wrote in message
> news:0BF65A91-2B70-49C7-B795-5CDF7167EEB4@microsoft.com...
> > Hi.
> > We have a client who has passed us a form they use for corporate emails.
> > Alongside the usual signature details (name, address, phone nos, email
> > address), there is a panel with their "offer" of the month, which they
> > change
> > monthly.
> > Below the signature, is a standard legal disclaimer.
> > At the bottom, there is a coloured panel containing the business address
> > and
> > contact details.
> > What they would like us to do, is adapt the form so that the user details
> > are extracted from Active Directory, so that everyone's email footers look
> > the same.
> > The .oft file we have been passed from the client as an example, is
> > dynamic
> > in relation to resizing the email window.
> > We have found a VBScript online (from Spiceworks), that extracts user
> > details from AD and puts them into a Word file and then adds it into the
> > signature area of Outlook. This is meant to go in to users' logon scripts.
> > Adapting .oft details to go into a signature in this manner looks very
> > tricky indeed!
> > The questions boil down to: Is this a viable thing at all ? Is the .oft
> > file
> > the best method ? If not, is there a better one ?
> > I hope my explanation of the problem makes sense. If not, I can try and
> > clarify.
> > Thanks!
> > Nick.


> .
>
 
An .oft file is not useful at all for sending messages on a routine basis.

If I wanted to require users to put a specific signature on all outgoing

messages, I'd use a server-based solution. Otherwise, I'd use a script to

build such a signature (in all 3 formats) and place it in the user's

Signatures folder.

Sue Mosher

"ngreen" <ngreen> wrote in message

news:885F22F7-AB8C-48DC-93D5-4845E7B458DF@microsoft.com...
> Sue,

> Thanks for your thoughts. I'll hunt down outlook object model details.

> This is intended as a signature to be appended to all outgoing emails.
> What
> would you recommend in preference to a .oft form ?

> Thanks,

> Nick.

> "Sue Mosher [MVP]" wrote:
>
> > If you have a script to get AD details and modify a Word document, the
> > same
> > techniques could be used with the Outlook object model to modify an
> > Outlook
> > message (i.e. one created from an .oft file that just lacks the
> > signature)
> > and save it as an .oft file.
>

>> Whether an .oft file is a good solution depends on exactly what you mean
> > by
> > "corporate emails" and the Outlook version. I would never use an .oft
> > file
> > like the one you describe for anything other than occasional boilerplate
> > mailings.
> > > > Sue Mosher
> > >> >> >
>
>> "ngreen" <ngreen> wrote in message
> > news:0BF65A91-2B70-49C7-B795-5CDF7167EEB4@microsoft.com...
> > > Hi.
> >> > We have a client who has passed us a form they use for corporate
> > > emails.
> > > Alongside the usual signature details (name, address, phone nos, email
> > > address), there is a panel with their "offer" of the month, which they
> > > change
> > > monthly.
> >> > Below the signature, is a standard legal disclaimer.
> >> > At the bottom, there is a coloured panel containing the business
> > > address
> > > and
> > > contact details.
> >> > What they would like us to do, is adapt the form so that the user
> > > details
> > > are extracted from Active Directory, so that everyone's email footers
> > > look
> > > the same.
> >> > The .oft file we have been passed from the client as an example, is
> > > dynamic
> > > in relation to resizing the email window.
> >> > We have found a VBScript online (from Spiceworks), that extracts user
> > > details from AD and puts them into a Word file and then adds it into
> > > the
> > > signature area of Outlook. This is meant to go in to users' logon
> > > scripts.
> >> > Adapting .oft details to go into a signature in this manner looks very
> > > tricky indeed!
> >> > The questions boil down to: Is this a viable thing at all ? Is the .oft
> > > file
> > > the best method ? If not, is there a better one ?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Lifelong Windows user - new to Mac - Help!!! Using Outlook 3
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
W OL giving basic auth when logged in to Win as specific user Using Outlook 0
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
icacream Outlook 2016 “Enter your user name and password for the following server.” Using Outlook 5
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
D Outlook 2010 Outlook in Windows 10 keeps asking for user name and password repeatedly Using Outlook 14
E Asking user to select multiple options in a list in an email Outlook VBA and Custom Forms 0
icacream Enter your user name and password for the following server. Using Outlook 4
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
S User Defined Fields adding new value (2) Using Outlook 0
R Creating a user defined function Outlook VBA and Custom Forms 3
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
G <mailto:user@domain.com<mailto:user@domain.com<mailto:user@domain.com>>> Using Outlook 5
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A Created a new user account and the local account cannot see email Using Outlook 3
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M other user's mailbox won't open, forms disappeared Using Outlook 42
S Custom user fields in received messages Outlook VBA and Custom Forms 1
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
P Change PC User Directory & iPhone Sync Using Outlook 2
J Assess content of User Defined Field in Rule Using Outlook 3
M How can I determine which user read an email Exchange Server Administration 4
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
R Prompt asking the user to send email to folder as *.msg file Outlook VBA and Custom Forms 1
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
N Select a folder in a user account Outlook VBA and Custom Forms 2
S Outlook User defined date field (UDF) not syncing Using Outlook 2
A How to enable outlook room finder (outlook connector (mapi)) user ? Using Outlook 3
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3

Similar threads

Back
Top