.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Add Column to show email has attachments

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :SharePoint



How can I add a column to a document libary to should that an email has an attachment.  I just want to mimic what you would see in outlook, ie the paperclip icon.



View Complete Post

More Related Resource Links

Column to show count of attachments uploaded for each List item in MOSS 2007


We have two requirements:

First, we need a column which shows the count of attachments that are for uploaded each item, the list structure is like below:

No. Of Files Attached Title Category Description Owner

How to show 0 as first number in column


Hi guys. I have two little problem.

I have database with one table and it has 4 rows.

1. I want to show a zero in front of all number. Actually i added but it doesn't show.

2. If i don't put any value in column is it possible to have minus for example instead of 0?




I post it like that because i can't see how to post pics directly.

P.S. The columns with numbers have checked "allow nulls".

I draw in paint so it's not so good but i think it's understandable.

10x in advance.

SQLCE table column DefaultValues don't show up in XSD Dataset designer

Using Visual Studio 2008 with SQL CE 3.5, I notice that default values in the creation scripts for the database tables are not reflected in the dataset designer XSD file.  For example, the following SQL script creates the non-nullable table column names "Content" with a default value of 'Image':    "Content" nchar(20) NOT NULL DEFAULT 'Image',But in the column properties of the dataset designer (XSD) panel, this column correctly shows up as non-nullable, but with a DBnull default value as follows:     Name: Content    Allow DBnull: False    DefaultValue: <DBnull>Am I missing something somewhere, or is this a VS bug?  Also, how do I get the XSD file to regenerate after schema changes in the database?  Sqlmetal doesn't do it.Thanks,    -BGood

How do I get a new column I created to show-up in the DisplayForm.aspx page?

Here's a little introduction to how I got here:

Downloaded the WSS Help Desk application template and installed it and now my company wants to add a column to the ServiceRequests list called "Service Request Type".  So I created a new column and made it a choice of "Incident" or "Change".  I then customized the EditForm.aspx and NewForm.aspx to provide the new entry.  Other than losing the ability to attach documents the forms are working perfectly and collecting the data.  My problem is that when I open the DisplayForm.aspx and attempt to add a new row and use the <xsl:value-of select="@SRType" /> I don't see any values displayed.  Also, I can browse  the Data Source Library and click on Service Requests > Show Data and see the new list item but when I choose the button for "Insert Selected Fields as...", the Item is greyed-out.  

Tried manually inserting code based-on similiar entries but still no luck.  Here's what I have so far:

      <td width="190px" valign="top" class="ms-formlabel">
         <H3 class="ms-standardheader">
           <nobr>Service Request Type</nobr>
      <td width="400px" valign="top" class="ms-formbody"><

How programmatically change Additional Column Settings - Show field?


Hello. I use the SPFieldUser in my list. I can change Additional Column Settings - Show field: "Name with Presense" on the "Name (with Picture and details)" using the WSS Web interface. How do it programmatically, using Object Model WSS?

email attachments being dropped from specific mail types


We have been using Bright mail and sending attachements to SharePoint without issue until September. 

Once into September any attachments comeing from Bright Mail are dropped. 

The attachment is in eml file... when timer job kicks off it strips the attachment - body and subject gets delivered....  We are thinking that perhpas with the month of September there is a character restriction??  Since the issue only started in September ... if we send the same atttachement from outlook it gets processed properly.  Wondering if there is possibly some issue between Bright Mail character size and sharepoint??

Any suggestions appreciated!

Default Column Values in a Document Library (SP2010) do not show up in word 2010 until you save and


when you create a document in a SP 2010 document library (of a particular content type, by clicking new, letter (content type name) in sharepoint for example) which has default values set on in in the library (set by using library settings -> change default column values), the default values do not show up until you create the document , save it and reopen it again.  Is this a bug or by design.  If it is by design, it is horrible since if some of the column default values are mandatory in the content type then you actually have to type them in before you could possibly save the file which defeats the whole point of having default column values.  Also it is tremendously clunky for a user to have to create file, save it , close it, and reopen it just to view the default metadata in the document information panel that is supposed to be there.

Anyone have any thoughts/solutions to this problem?


SP2010 - Email with multiple attachments


We have SP2010 and Exchange 2007 and most users working with Outlook 2007.  I've doen a search but wasn't able to find any relevant information on this site or the web.  We can easily select a document and click the "Email A Link" button in the ribbon and send the email with a link.  What we can't seem to do is select multiple documents and then email the selected links. Is there a setting somewhere for this, another way to do it, or am i just hosed on this one?



how to add this two sum column to show in one


hi this is my query im struct

select SUM(a.SqFt + b.SqftDespatch)as Qt  from dbo.Batch_reg a 
left join dbo.QCM_Descp b on a.BatchNo=b.BatchNo where a.MPONo='M1'

select SUM(a.qty) as Qt, SUM(b.Dqty) as Qt1  from dbo.table1 a 

left join dbo.table2 b on a.No=b.DNo where a.No='M1'

im getting output like this

Qt          Qt1

1500      200

I need output like this


Note: if Qt1 return Null then i need to show 1500 only for above example.

how to do?

Show column headers when gridview returns empty data set




I have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet. 

Only date is displayed in modified column. How do I get it to show time also?


I can't find out how to set the format for this column in document libraries. I have seen the column also display time so I know it's possible.



Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns


I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i c

Document Library incoming email attachments not showing To/From information


I have a document library setup to accept incoming emails as attachments.

When I send an email the document library receives it, the only problem is it doesn't show any of the header information such as who sent it, who it was sent to, who was CC'ed.  Is there any way to have this information shown?

Basically what I'm expecting to see before the body message is the From, To and CC.

Any help would be most appreciated.

How to show column value in display mode and hide in edit mode?


How to show column value in display mode and hide in edit mode for my custom page layout?

I need similar functionality like PublishingWebControls:EditModePanel with contrary behavior.

I cannot use nor server-side code neither third-party web-parts. Only pure APSX+SP Contol Libraries and client JS allowed.

email alert notification when task status column value is chaned


Hi All,

I am creating a document library in which there are few columns present (like Assigned To,Task Status,Reviewr etc.)

I want to send alert or email notification when the status value is changed. Alert should go to "Assigned To" selected value from the Reveiwers name.

I have tried this with "alert me" functionality provided by WSS 2007 but I think it will not sufficient for me?.

I am not able to proceed please help me?

"Email a link" column



I'm new to sharepoint so I don't know how easy or difficult this is.

I am building a document library in Sharepoint 2010 and I need to display the url's of the documents in a column.  This url will be read by a program outside of our sharepoint.  I was able to add the URL Path column through SPD but I need the http://mycompany before that path.  Basically, I need it to look the same as the "email a link" without copy and pasting mannually everytime.

Any help would be greatly appreciated.



Customized CQWP column are not show after publishing sharepoint 2007


Hi All,


I create a custom CQWP programmatically where i show two or three different column. When i configure it it work fine in "Edit Mode" (means all columns are visible) but when i check in only the title field is shown to me other field are invisible again when i edit the page all things are fine....Kindly help me...

Thanks and Regards Er.Pradipta Nayak
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend