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.
 
S

Sue Mosher [MVP]

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.
 
N

ngreen

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.
 
N

ngreen

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.


> .
>
 
S

Sue Mosher [MVP]

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
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
B ActiveExplorer return NULL on new Window user login and running Outlook first time Using Outlook 1
S how to set user properties to a newly created appointment Outlook VBA and Custom Forms 12
S VBA with User Defined fields Outlook VBA and Custom Forms 9
D Unable to Send On Behalf of Another User Exchange Server Administration 0
M Exchange 2013 On premise set MessageRateLimit for User has no effect. Exchange Server Administration 0
A Block user to send emails to specific set of email ids Using Outlook 1
A UID field in iCal files - unique per-event or per-user or both? Using Outlook 2
G how can Apply User-defined Field to all Sub Folder and Other Using Outlook 14
C Custom Application Form send Email to Another User Using Outlook 1
B Auto Save of Attachments from Multiple Emails and forward attachments to user group Outlook VBA and Custom Forms 1
C Where are BCM User Customizations located? BCM (Business Contact Manager) 9
Mark Foley Outlook prompts for IMAP user/PW when domain PW changes Using Outlook 0
M Map Outlook user defined fields onto a Sharepoint list ??? Outlook VBA and Custom Forms 1
O Promoting Outlook 2003 User Templates Using Outlook 1

Similar threads

Top