Cannot remove unwanted fields from form

Status
Not open for further replies.

Hallam Riggs

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi all,

I'm editing an old form that has been in circulation around our trust for a few years now. It was created around 2004 by someone in the IT department who is long gone from our organisation. When I joined I cobbled together a new version of the form by using a basic knowledge of Outlook. This is now in need of upgrading to a standard beyond my capabilities (and beyond anyone in our IT setup.)

The form is used to request files from a library. The information is filled in, then the form is emailed to the library mailbox. There are 2 tabs - the first for users to put the information of what they require, and the second is information on who they are and how fast they need it.
On the second tab (named 'Information' - pic2) I can edit all the fields and make it work completely for our needs. On the first tab though (named 'Task' - pic1), I cannot remove the fields I do not require, namely 'Start Date', 'Status', 'Prioirty' and '% Complete'.
This is causing problems when trying to simplify our procedures for staff already having to jump through hoops. Anyone know how I can get rid of these?!

Pic1


Pic2
 

Hallam Riggs

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Thanks for your reply Diane.

Is there any way I can hide all of those fields from that page on a print out? They all still appear when I print the task.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
No, not using Outlook's default print functions. You could use a macro to send the fields you want to include in the printout to Word or even to a new outlook message and print.
 

Hallam Riggs

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Well that's gone beyond my range of knowledge! Thanks again for your help though!
 

Hallam Riggs

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Wow, just seen this! This looks excellent - having an issue with that working - is there a version of this code available with all of the default fields already removed, leaving a blank canvas to work on?
 

Hallam Riggs

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hi (again!) Diane!

I put together this last night :):

Code:
Sub PrintTasks()
Dim olTask As Outlook.TaskItem, olMsg As Outlook.MailItem
Dim strBody As String
For Each olTask In Application.ActiveExplorer.Selection
strBody = strBody & olTask.UserProperties("Subject") & vbCrLf & olTask.Body & vbCrLf & olTask.UserProperties("Contact Name") & vbCrLf & olTask.UserProperties("Contact Number") & vbCrLf & olTask.UserProperties("iPM Location") & vbCrLf & olTask.UserProperties("iPM Service Point") & vbCrLf & olTask.UserProperties("iPM Use") & vbCrLf & olTask.UserProperties("Level") & vbCrLf & olTask.UserProperties("Routine") & vbCrLf & olTask.UserProperties("Special Instructions")
Set olMsg = Application.CreateItem(olMailItem)
With olMsg
.BodyFormat = olFormatPlain
.Body = strBody
.Display
.PrintOut
.Close olDiscard
End With
Next
Set olMsg = Nothing
End Sub
A couple of questions (sorry to keep asking - I am quite amateur at this!!!)
How do I keep the field titles? These would be quite useful to us.
How do I direct this to an inbox? It only works on items in my personal tasks. As the task is emailed into our mailbox, it needs to point to that.
Is there any way to add an automatic acceptance of the task into this process as well?
The body does not display a table contained within it. Will it only print as text? Any way I change that?

Thank you so much for your continued help - there is a small corner of South West England that is working much better because of your input!!!
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
1. Write the field's name before its value. It's clearer if you use one line for each field:
strBody=strBody & "Subject: " & olTask.Body & vbcrlf
strBody=strBody & "next field: & ..... & vbcrlf

2. It points to the current selection. If you want to select an email, the olTask variable must be declared As Outlook.MailItem instead of Outlook.TaskItem.

3. Plain text cannot have formattings or a table. Change the format from olFormatPlain to olFormatHtml to keep the table. It could be necessary to format the text then by using html tags. For instance, html cannot display a line break if you write vbcrlf, instead you need to replace it by <br>.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
T Cannot remove needless PST Using Outlook 1
J Your IMAP server wants to alert you to the following: cannot remove system folder Using Outlook 3
E Cannot remove crashed account from Outlook Using Outlook 1
D cannot remove email account type = Microsoft Exxchange Using Outlook 3
P Cannot permanently remove from Outlook Favorite Folders Using Outlook 4
J Cannot Remove a POP3 Account Using Outlook 2
T Cannot remove account Using Outlook 1
D Outlook: Cannot remove Exchange home account. Using Outlook 1
K Cannot Remove Exchange 2003 Following Exchange 2010 Transition Exchange Server Administration 7
D Cannot remove Hub Transport role: error code 1638 Exchange Server Administration 13
G Cannot Move Autocomplete File to New Computer Using Outlook 12
rubaboo The vew cannot be found Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
L Cannot open PST file for first session each day Using Outlook 6
David in Mississippi New (Feb 2020) install of Outlook 365 - Cannot specify PST for different accounts Using Outlook 0
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
noshairwan Registry cannot be found, Outlook Security Using Outlook 2
Marc2019 Cannot input Vietnamese Characters on my MSOutlook 2016 in Windows 7 Using Outlook 0
Marc2019 Cannot setup Outlook Account on Mac Os 10.6.8 Using Outlook 3
N pst files are recreating automaticaly and cannot be deleted Using Outlook 6
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
T "cannot find the calendar folder for this item" - calendar items stuck in outbox Using Outlook 0
A Created a new user account and the local account cannot see email Using Outlook 3
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
T Cannot connect to main BT email account, sub accts okay Using Outlook 0
O The page that you are trying to access cannot be loaded. Using Outlook 0
M Daily Task List Minimized Cannot Display Using Outlook 2
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
B One email cannot be sent or received (but leaves outbox!) Using Outlook 1
C Outlook 2016 cannot delete, email showing in root Exchange Server Administration 5
S Outlook.com cannot edit some contacts Using Outlook.com accounts in Outlook 5
B Search: Cannot find which Folder Contains a Message Using Outlook 3
C Outlook - cannot save subject line changes Using Outlook 2
M cannot change delivery folders with IMAP accounts Using Outlook 0
S Appointment-Cannot set Categories because ConversationID is not set Outlook VBA and Custom Forms 1
Fozzie Bear Cannot post "Sneaky URL"!! Using Outlook.com accounts in Outlook 2
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
S Outlook 2010 Cannot Open Attachments Using Outlook 14
A Cannot Figure Out This VBA Outlook VBA and Custom Forms 2
A Cannot Figure Out One Thing on VBA Outlook VBA and Custom Forms 2
Brian Murphy Exchange Online Everything a Transport Rule should do and cannot Exchange Server Administration 1
A Error: The name cannot be matched to a name in the address list Using Outlook.com accounts in Outlook 0
K Other Shared Calendar on Outlook cannot change items Using Outlook.com accounts in Outlook 7
T Outlook 2016 cannot connect after transition to Outlook Mail Using Outlook.com accounts in Outlook 4
L Cannot Connect to BCM database BCM (Business Contact Manager) 9
A Cannot connect to BCM database BCM (Business Contact Manager) 3
Diane Poremsky The custom form cannot be opened. Outlook will use an Outlook form instead. New Slipstick.com Articles 0
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
T Outlook 2016 mp3 attach "this file cannot be preview because there is no previewer installed for it" Using Outlook 1
Similar threads


















































Top