Hi,

  I am trying to get rid of word automation on a site.  I've been looking at
WordML, XML, XSD, etc., but can't find 1 good example of how to do what I
need to.  It's a pretty simple task, I think.  All I need to do is query our
SQL server and get a recordset (which I can do with ease), then create a
word (xml) file which will be setup as Avery labels (5160), then send the
file down to the user  I've seen lots of references to using an XSD, and
I've generated one using VS 2005 (see end of message).  However, it seems to
have a lot of extra "crap" in it, so it's a bit confusing.  Does anyone have
a good example/reference on just how the heck to do this?

Any help would be greatly appreciated!

Chad

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Labels" targetNamespace="http://tempuri.org/Labels.xsd"
xmlns:mstns="http://tempuri.org/Labels.xsd"
xmlns="http://tempuri.org/Labels.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0"
FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout,
AnsiClass, Class, Public" SchemaSerializationMode="ExcludeSchema"
xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
        </Connections>
        <Tables>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Labels" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Labels"
msprop:Generator_DataSetName="Labels">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Labels" msprop:Generator_UserTableName="Labels"
msprop:Generator_RowDeletedName="LabelsRowDeleted"
msprop:Generator_TableClassName="LabelsDataTable"
msprop:Generator_RowChangedName="LabelsRowChanged"
msprop:Generator_RowClassName="LabelsRow"
msprop:Generator_RowChangingName="LabelsRowChanging"
msprop:Generator_RowEvArgName="LabelsRowChangeEvent"
msprop:Generator_RowEvHandlerName="LabelsRowChangeEventHandler"
msprop:Generator_TablePropName="_Labels"
msprop:Generator_TableVarName="tableLabels"
msprop:Generator_RowDeletingName="LabelsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="First_Name"
msprop:Generator_UserColumnName="First_Name"
msprop:Generator_ColumnPropNameInRow="First_Name" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnFirst_Name"
msprop:Generator_ColumnPropNameInTable="First_NameColumn" type="xs:string"
minOccurs="0" />
              <xs:element name="Last_Name"
msprop:Generator_UserColumnName="Last_Name"
msprop:Generator_ColumnPropNameInRow="Last_Name" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnLast_Name"
msprop:Generator_ColumnPropNameInTable="Last_NameColumn" type="xs:string"
minOccurs="0" />
              <xs:element name="Address1"
msprop:Generator_UserColumnName="Address1"
msprop:Generator_ColumnPropNameInRow="Address1" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnAddress1"
msprop:Generator_ColumnPropNameInTable="Address1Column" type="xs:string"
minOccurs="0" />
              <xs:element name="Address2"
msprop:Generator_UserColumnName="Address2"
msprop:Generator_ColumnPropNameInRow="Address2" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnAddress2"
msprop:Generator_ColumnPropNameInTable="Address2Column" type="xs:string"
minOccurs="0" />
              <xs:element name="City" msprop:Generator_UserColumnName="City"
msprop:Generator_ColumnPropNameInRow="City" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnCity"
msprop:Generator_ColumnPropNameInTable="CityColumn" type="xs:string"
minOccurs="0" />
              <xs:element name="State"
msprop:Generator_UserColumnName="State"
msprop:Generator_ColumnPropNameInRow="State" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnState"
msprop:Generator_ColumnPropNameInTable="StateColumn" type="xs:string"
minOccurs="0" />
              <xs:element name="Zip" msprop:Generator_UserColumnName="Zip"
msprop:Generator_ColumnPropNameInRow="Zip" msprop:nullValue="_empty"
msprop:Generator_ColumnVarNameInTable="columnZip"
msprop:Generator_ColumnPropNameInTable="ZipColumn" type="xs:string"
minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>