Export task list view settings to other pc

Status
Not open for further replies.

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Hi

I run a one man consultancy service here in Denmark. Part of my business is onhandling mails and tasks in Outlook efficiently. One of my advices require a specific task list view setting, which the participants in my courses have to set up themselves guided by me in class. That's a drag and the faster ones are getting bored along the process.

Is there anyway that I could export my task list view settings and copy/install/export to the participants' pcs, so we could skip the set up process?

I am aware that the different versions and language setup of Outlook probably will require a version specific file/vba or whatever will solve the problem.

Kind regards
John
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Thank you, Diane. I can get it to work with the mail view, but not with the task views, which are the ones I would like to share/export. The .pst file seems to disappear when I switch to tasks. I can still find it when I return to the inbox
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Is there a task folder in the pst? Create a task folder in it then copy the Task view to it, using the 'this folder' view type.
 

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Thanks for your patience :)

Yes, there is a task folder in the .pst - I've named it ExportViews. I even tried creating one more called "Opgaver" (danish for tasks). That didn't work either.

Maybe the problem is that when I switch to tasks the .pst file does not show? When I try to adding it I am forced back to the inbox even though I created the .pst from the task window.

I'll happily pay for your time if we can solve this.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I'll walk through the steps here and see if i can repro your problems.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
This sample shows how to read the view by VBA: Copy Folder Views - VBOffice
You could, for instance, write the xml property to the body of an email. However, with this approach you´d need to install a macro to import from the email on all the users computers. Not sure, if that´d accelerate anything.
 

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Hi Michael

Thanks for the suggestion and your time. Unfortunately I'm not able to write macros. I get the idea though. I think I could send the macro to import in a seperate mail and let the users install the macro. Then import the view from a mail containing the xml property. That could work and it would accelerate the process. At the moment it takes about 30 minutes to set up the two views in question. Do you think that'll work?
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
To write the view into an email, replace everything within the first If and last End IF by this one:
Code:
Dim Mail as MailItem
set mail=application.createitem(0)
mail.body=sourcefolder.currentview.xml
mail.save
Make sure there´s only the view definition in the body, no signature etc.

This one saves the view from the email to the current folder. Have the user first open the email with the view, then select the folder where the view should be copied to:
Code:
sub Importview()
dim mail as mailitem
set mail=application.activeinspector.currentitem
dim view as view
set view=application.activeexplorer.currentfolder.view
view.xml=mail.body
view.apply
end sub
 

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Thank you so much, Michael. I can now write the settings into a mail. But when I try to import it, I get an error message even though I follow your instructions.

When I try to debug it points to the line below ↓

Udklip.PNG


I have tried running the macro from the mail as well as from the tasks in the specific folder.

Do you have an idea what to do?

Thanks in advance.
John
 

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Oh, just to be clear... it gives me the following message: Run time error '438': Object doesn't support this property or method.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
My fault, it must be
Code:
set view=application.activeexplorer.currentfolder.currentview
 

JohnViuf

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
Thanks a lot, Michael. It works like a charm now. I am really grateful
 

John Ismyname

New Member
Outlook version
Outlook 2016 32 bit
Email Account
IMAP
When I run the first part of this,CopyView, the selector comes up and I select a task folder as a directory and then.. nothing. This is what I would expect as it is does copy. When I run the second part, ImportView, I get the error message "Run-time error '91': Object variable or With block variable not set" . When I click debug, the following code line is highlighted "Set mail = Application.ActiveInspector.CurrentItem" The complete script I am using is shown below.

Please advise - John


Public Sub CopyView()
Dim SourceFolder As Outlook.MAPIFolder
Dim TargetFolder As Outlook.MAPIFolder

Set SourceFolder = Application.Session.PickFolder

If Not SourceFolder Is Nothing Then

Dim mail As MailItem
Set mail = Application.CreateItem(0)
mail.Body = SourceFolder.CurrentView.XML
mail.Save

End If
End Sub

Sub Importview()
Dim mail As MailItem
Set mail = Application.ActiveInspector.CurrentItem
Dim view As view
Set view = Application.ActiveExplorer.CurrentFolder.CurrentView
view.XML = mail.Body
view.Apply
End Sub

vbsscript.png
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Actually, ignore that - the code looks right. I need to read the rest of the thread. :)
The code in the screenshot is wrong - that is used for a message item - you need to use folder code
Set view = Application.ActiveExplorer.CurrentFolder.CurrentView
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Ok... I'm not getting an error when i run it - you need to have the message open that contains the view code (add mail.Display before the save line) - but adding the view to the other task folder isn't working.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
V Launching Access export from Outlook task, Access Password pop-up window gets lost Using Outlook 1
R Outlook 2010 How do you export 2 email Accounts' 2010 Inbox Files to new computer (2019)? Using Outlook 1
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
M Export-Import .pst file problems Using Outlook 2
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 2
S How to export urls from email to excel and check the status of the url ? New Slipstick.com Articles 6
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
P How to export voting results using VBA? Outlook VBA and Custom Forms 2
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
N Export details to a excel spreadsheet using macros Using Outlook 0
avant-guvnor Export Calendar, Birthdays and Holidays Outlook VBA and Custom Forms 0
Diane Poremsky Export (Save) Outlook Contact photos New Slipstick.com Articles 0
K Macro to search emails between two time slots on public folders with excel export Outlook VBA and Custom Forms 12
A How to export one email data to excel Using Outlook 1
B Macro To Create Rule To Export From Certain Folder Email Information in one workbook multiple sheets Outlook VBA and Custom Forms 0
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
E Exchanger service export detection Exchange Server Administration 1
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
H How to export *all* fields from Outlook Using Outlook 2
K Export Organizational Forms Library Exchange Server Administration 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
E RSS export as OPML problem Using Outlook 4
A export free / busy from exchange Exchange Server Administration 0
C Export to excel missing items, but a larger total? BCM (Business Contact Manager) 6
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
T Outlook 2007 Export tasks to Excel Using Outlook 2
J Opening/Archiving/Import/Export PST files Using Outlook 4
H Select one of Contact-Mailadesses to Export > Excel or Winword Outlook VBA and Custom Forms 2
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
S Requried a VBA Code to export Calander details to excel... Outlook VBA and Custom Forms 4
Jennifer Murphy Can I export individual emails? Using Outlook 1
R Export Address Book VBA Using Outlook 0
W How to export additional fields in contacts Using Outlook 1
R Recover/export rules from a backup .PST Using Outlook 2
J Formatting Contacts to Export for iPhone Using Outlook 0
B No export way Using Outlook 4
F Export Outlook contacts by One Category Using Outlook 1
Jennifer Murphy Difference between export and archive? Using Outlook 10
J How can I EXPORT my email address bok? Using Outlook 1
D Macro to export mail data based on assigned category Using Outlook 3
W calendar contacts export problem Using Outlook 1
M outlook shared calendar data export to excel sheet Using Outlook 1
Similar threads


















































Top