I was commenting the other day at the office that 3 months ago, no-one was doing anything with SharePoint and now there are five of us.  Sadly, I am one of them :(

As per previous posts I tend to either love or hate SharePoint.  The cycle of mixed emotions is continuous and ever increasing in velocity.  Fairly soon, it will be a blur and I will feel either suicidal or manically happy.

However, over the last month or so I have learnt a lot about MOSS, InfoPath, Forms Services, Workflow and other related stuff.  This is the project:

1. MOSS is exposed to the Internet and the UI is customised with SharePoint Designer so it looks half decent.
2. User logs into site - site is configured with custom membership and role providers that uses a SQL database.  The database contains data from MS CRM and other stuff.  Someone else in the office has created a membership provider that talks directly the the MS CRM web services but in this case we didn't want to do this - the customer does not have the CRM Internet connector license.
3. User browses the site and clicks a button to view an InfoPath form in the browser.
4. The form displays data from web services and lists. 
5. User can save a draft of the form or submit it.  The form is submitted to a form library in SharePoint.
6. A workflow attached to the form library sends the form's xml via a custom Workflow Activity to a web service.
7. The Web Service inserts the XML into a Word DOCX file and emails the file to a couple of address.

Along the way, I've discovered a few things so I thought it was about time I documented and shared a few tips.

Today's tip follows...