<?xml version="1.0"?>
<Reports>
  <FormatVersion>1.0 1.0.0.0</FormatVersion>
  <Report ref="1">
    <Name>Mail Merge</Name>
    <DataSourceName>Main</DataSourceName>
    <Layout>
      <Width>11895</Width>
      <Orientation>Portrait</Orientation>
    </Layout>
    <Font>
      <Name>Verdana</Name>
      <Size>9</Size>
      <Bold>false</Bold>
      <Italic>false</Italic>
      <Underline>false</Underline>
      <Strikethrough>false</Strikethrough>
    </Font>
    <DataSources>
      <DataSource>
        <Name>Main</Name>
        <DataProvider>OLEDB</DataProvider>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|C1NWind.mdb;Persist Security Info=False</ConnectionString>
        <RecordSource>SELECT 
Customers.CustomerID, Customers.CompanyName, 
Customers.ContactName, Customers.Address, 
Customers.City, Customers.Region, Customers.Country, Customers.PostalCode, Orders.OrderID, Orders.OrderDate, [Order Subtotals].Subtotal
FROM Customers INNER JOIN ([Order Subtotals] INNER JOIN Orders ON [Order Subtotals].OrderID = Orders.OrderID) ON Customers.CustomerID = Orders.CustomerID WHERE CompanyName = "Ernst Handel"</RecordSource>
      </DataSource>
    </DataSources>
    <Sections>
      <Section>
        <Name>Detail</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>3615</Height>
            <AutoHeight>None</AutoHeight>
          </SubSection>
        </SubSections>
        <Type>Detail</Type>
        <AutoHeight>None</AutoHeight>
      </Section>
      <Section>
        <Name>Header</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>2520</Height>
          </SubSection>
        </SubSections>
        <Type>Header</Type>
      </Section>
      <Section>
        <Name>Footer</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
          </SubSection>
        </SubSections>
        <Type>Footer</Type>
        <Visible>false</Visible>
      </Section>
      <Section>
        <Name>PageHeader</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>105</Height>
          </SubSection>
        </SubSections>
        <Type>PageHeader</Type>
      </Section>
      <Section>
        <Name>PageFooter</Name>
        <SubSections>
          <SubSection>
            <Name>SubSection1</Name>
            <Height>500</Height>
          </SubSection>
        </SubSections>
        <Type>PageFooter</Type>
        <Visible>false</Visible>
      </Section>
    </Sections>
    <Fields>
      <Field>
        <Name>Field6</Name>
        <Section>Detail</Section>
        <Left>75</Left>
        <Top>0</Top>
        <Width>1110</Width>
        <Height>315</Height>
        <MarginLeft>50</MarginLeft>
        <Text>Name</Text>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field8</Name>
        <Section>Detail</Section>
        <Left>3495</Left>
        <Top>0</Top>
        <Width>1560</Width>
        <Height>315</Height>
        <MarginLeft>50</MarginLeft>
        <Text>Company Name</Text>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field4</Name>
        <Section>Detail</Section>
        <Left>900</Left>
        <Top>0</Top>
        <Width>1950</Width>
        <Height>285</Height>
        <Text>ContactName</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field11</Name>
        <Section>Detail</Section>
        <Left>4950</Left>
        <Top>0</Top>
        <Width>2325</Width>
        <Height>270</Height>
        <Text>CompanyName</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field7</Name>
        <Section>Detail</Section>
        <Left>75</Left>
        <Top>270</Top>
        <Width>1095</Width>
        <Height>285</Height>
        <MarginLeft>50</MarginLeft>
        <Text>Country</Text>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field9</Name>
        <Section>Detail</Section>
        <Left>3495</Left>
        <Top>270</Top>
        <Width>1545</Width>
        <Height>285</Height>
        <MarginLeft>50</MarginLeft>
        <Text>Order Date</Text>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>true</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field10</Name>
        <Section>Detail</Section>
        <Left>4980</Left>
        <Top>270</Top>
        <Width>2280</Width>
        <Height>255</Height>
        <Text>OrderDate</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field5</Name>
        <Section>Detail</Section>
        <Left>885</Left>
        <Top>285</Top>
        <Width>1905</Width>
        <Height>285</Height>
        <Text>Country</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field2</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>5</Width>
            <Color>00FFFFFF</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>5</Width>
            <Color>00FFFFFF</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>5</Width>
            <Color>00FFFFFF</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>5</Width>
            <Color>00FFFFFF</Color>
          </Bottom>
        </Border>
        <Background type="Solid">
          <Color>FFFEF5DA</Color>
        </Background>
        <Section>Detail</Section>
        <Left>45</Left>
        <Top>720</Top>
        <Width>9180</Width>
        <Height>1935</Height>
        <MarginLeft>300</MarginLeft>
        <MarginTop>300</MarginTop>
        <MarginRight>300</MarginRight>
        <MarginBottom>300</MarginBottom>
        <AutoHeight>CanGrow</AutoHeight>
        <Text>"Dear " + ContactName + "," + vbcrlf + vbcrlf + _
"Your order for past year totals to " + Format(Subtotal, "Currency") + vbcrlf + vbcrlf + _
"Because you have been such a terrific customer, " + _
"we decided to credit your account with $0.10. The amount will be credited in next 10 days. Your Adress for future correspondance is "+"Address" + vbcrlf + vbcrlf + _
"Congratulations!"</Text>
        <Calculated>true</Calculated>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field12</Name>
        <Section>Header</Section>
        <Left>63</Left>
        <Top>79</Top>
        <Width>1058</Width>
        <Height>963</Height>
        <Picture>
          <Image> </Image>
        </Picture>
      </Field>
      <Field>
        <Name>titleLbl</Name>
        <Background type="Solid">
          <Color>FFFFFFFF</Color>
        </Background>
        <Section>Header</Section>
        <Left>1074</Left>
        <Top>190</Top>
        <Width>4200</Width>
        <Height>600</Height>
        <Text>C1Works Enterprise</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>24</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft2</Name>
        <Section>Header</Section>
        <Left>5310</Left>
        <Top>495</Top>
        <Width>1425</Width>
        <Height>300</Height>
        <Text>Today</Text>
        <Align>RightMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>ftrLeft1</Name>
        <Section>Header</Section>
        <Left>6810</Left>
        <Top>495</Top>
        <Width>2565</Width>
        <Height>300</Height>
        <Text>Now()</Text>
        <Calculated>true</Calculated>
        <Align>LeftMiddle</Align>
        <ForeColor>FF666666</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>titleLbl1</Name>
        <Section>Header</Section>
        <Left>1050</Left>
        <Top>584</Top>
        <Width>3947</Width>
        <Height>379</Height>
        <Text>Mail Merge</Text>
        <Align>LeftMiddle</Align>
        <ForeColor>FF007D9D</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>12</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
      <Field>
        <Name>Field3</Name>
        <Border>
          <Left>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Left>
          <Top>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Top>
          <Right>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Right>
          <Bottom>
            <Style>Solid</Style>
            <Width>15</Width>
            <Color>FF0070C0</Color>
          </Bottom>
        </Border>
        <Section>Header</Section>
        <Left>75</Left>
        <Top>1770</Top>
        <Width>9135</Width>
        <Height>105</Height>
        <Font>
          <Name>Verdana</Name>
          <Size>10</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
        <Shape type="LineShape" />
      </Field>
      <Field>
        <Name>Field1</Name>
        <Section>Header</Section>
        <Left>0</Left>
        <Top>2025</Top>
        <Width>9135</Width>
        <Height>480</Height>
        <MarginLeft>200</MarginLeft>
        <AutoHeight>GrowAndShrink</AutoHeight>
        <Text>This report has a single calculated field that builds a letter for each 'customer' (actually the products).</Text>
        <Align>LeftTop</Align>
        <ForeColor>FF333333</ForeColor>
        <Font>
          <Name>Calibri</Name>
          <Size>9.75</Size>
          <Bold>false</Bold>
          <Italic>false</Italic>
          <Underline>false</Underline>
          <Strikethrough>false</Strikethrough>
        </Font>
      </Field>
    </Fields>
  </Report>
</Reports>