Hi Suresh,

As I think you've discovered by the feedback thus far, you are limited to 255 characters in the BillingInformation property for a MailItem. What I would suggest is you take a look at adding a custom property to the UserProperties object and in this case the type of property would be that of text.

I might be mistaken but I don't think it has the same 255 character limit and, even if it did, then you simply add enough additional UserProperties that will allow you to populate the quantity of file numbers in question.

While I have done a lot of integration with various Office products, I have yet to use this specific property/ object and so I don't have code to share at the moment. If I have a chance in the near future I may attempt to do so.

HTH...regards,

Mark

Thanks all for your help. I agree that this is an Outlook forum question.

Thanks much Andreas,

when i check the length of the assigned values it looks like all the values (5218) were assigned to the BillingInformation column (attached screenshot).

I tried to manual to insert data to billinginformation field from outlook.

The max length of string I was able to type was 255 chars long.

So this is a limitation in Outlook.

Andreas.

Hi.

I guess that John's answer about length might be critical. You said you can pass 32 first file id's to the specific field. I do see that file id's have an average length of 7 chars. 7 * 32 = 224 + 32 comma = 256. Of course I make some assumptions. But it may be that this field is limited to something like 255 chars length. Unfortunately, like John, I wasn't able to find official details about this field length.

Can you check the length size of contents in the field after value assignment?

Andreas.

Hi, Suresh -

This appears to be more of an Outlook question than it is a PB question. You might wish to consider asking how to accomplish this task in an Outlook forum, as the question might by seen by a higher number of Outlook-knowledgeable people. I looked at the documentation of the BillingInformation property of a MailItem object, which says the property is simply a string. There is no mention of any length limitations.

    https://learn.microsoft.com/en-us/office/vba/api/outlook.mailitem.billinginformation

What I'm about to suggest may not make any difference, but have you considered using a different separator/delimiter character than a comma?

Good luck and best regards, John

My first thought:  is it possible to use more than one BillingInformation object at a time?

My second thought:  Can you convert the information in the BillingInformation object, or the data that would normally go into such an object, into plain text in the message itself?

Final thought:  Rather than population the BillingInformation object, populate a TEXT file and send it as an attachment.