From field in outlook 2007

[JohnP]

We have a user who will be using multiple stationaries (.oft), she would like to know if the FROM field can be hardcoded with the mailbox name. She is using outlook 2007 client

 

[larry]

As long as the From name is an actual account and not a shared mailbox address, you can save the template with the account selected and it should work (it did years ago). If that doesn't work, you can set the account and open the template using a macro.

 

[Diane Poremsky]

if you need to use a macro, start with this one - http://www.slipstick.com/outlook/hyperlink-templates/ - you'll just need to add the code to set the account as it opens..... but it should work to set the account then save the template.

 

[JohnP]

Larry, she has 10 shared mailboxes to manage and she doesn't want to add the name of every mailbox when shes using the templates

 

[Diane Poremsky]

Unfortunately, it's not possible to pull in the mailbox name when you use a template (it works when you use the standard message form and have multiple accounts) - they use the default account unless they are published to the folder. She'll need to use a macro to set the address or set it herself.

 

[JohnP]

We created 10 folders with all the templates by shared mailbox. Is there a way to open the folder instead of the templates. This macro only works if I specify only one template.

Sub MakeItem()
Set newItem = Application.CreateItemFromTemplate("C:\DATA\TEMP\LALA.OFT")
newItem.Display
Set newItem = Nothing
End Sub

 

[Diane Poremsky]

Yeah, you'd need a bunch of macros... you can open a folder using the code - after setting the variable for the folder, use

Sub Whatever()
Dim Ns As Outlook.NameSpace
dim oFolder as outlook.folder
Set Ns = Application.GetNamespace("MAPI")
'use the default folder
Set oFolder= Ns.GetDefaultFolder(olFolderCalendar)
oFolder.display
End Sub

http://www.slipstick.com/developer/working-vba-nondefault-outlook-folders/