Word 2007 Mail Merge Data Source

> seems to give the appearance that you can
> have more than one since the Data Source field is fairly large and has the
> appearance of having a scroll bar.

This is probably because this dialog box is shared with Publisher 2007,
which allows the user to select multiple sources, in effect merging them
into a single flat-file for the purposes of the merge.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"JeffreyBee" <JeffreyBee.TakeThisOut@discussions.microsoft.com> wrote in message
news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
> Hello,
>
> Is it possible to use more than one data source for a mail merge in Word
> 2007? I know in previous versions of Word you can not however the Mail
> Merge
> Recipeits dialog box in Word 2007 seems to give the appearance that you
> can
> have more than one since the Data Source field is fairly large and has the
> appearance of having a scroll bar.
>
> I tried to add a second data source but was not successful.
>
> Thanks for any insight you can pass along.

"Doug Robbins - Word MVP" wrote:

> No, all versions of Word can only use a single flat file as a datasource.
> To use data from more than one original source, it is necessary to
> combine/extract the data into a single source if you want to merge it into a
> document.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "JeffreyBee" <JeffreyBee.RemoveThis@discussions.microsoft.com> wrote in message
> news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
> > Hello,
> >
> > Is it possible to use more than one data source for a mail merge in Word
> > 2007? I know in previous versions of Word you can not however the Mail
> > Merge
> > Recipeits dialog box in Word 2007 seems to give the appearance that you
> > can
> > have more than one since the Data Source field is fairly large and has the
> > appearance of having a scroll bar.
> >
> > I tried to add a second data source but was not successful.
> >
> > Thanks for any insight you can pass along.
>
>
>

Doug

I am sorry but you are wrong. I have word doc's that used merge fields from
1 source and an inserted dbf data table from another source via oledb. I used
them in 2000 and 2003. I created a headersource and a datasource doc to merge
the field data. The inserted dbf updated itself when merge was executed. NONE
of this works in 2007. I have the merge field part working using
OpenDataSource but the inserted dbf will not refresh. Can you help with that?

Thanks Chuck

"Doug Robbins - Word MVP" wrote:

> No, all versions of Word can only use a single flat file as a datasource.
> To use data from more than one original source, it is necessary to
> combine/extract the data into a single source if you want to merge it into a
> document.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "JeffreyBee" <JeffreyBee.DeleteThis@discussions.microsoft.com> wrote in message
> news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
> > Hello,
> >
> > Is it possible to use more than one data source for a mail merge in Word
> > 2007? I know in previous versions of Word you can not however the Mail
> > Merge
> > Recipeits dialog box in Word 2007 seems to give the appearance that you
> > can
> > have more than one since the Data Source field is fairly large and has the
> > appearance of having a scroll bar.
> >
> > I tried to add a second data source but was not successful.
> >
> > Thanks for any insight you can pass along.
>
>
>

Without knowing how you did it before, I do not think that I can help you,
except to say that the way I would probably do it would be to use a
"roll-your-own" equivalent to mail merge that used a template containing
DOCVARIABLE fields in place of merge fields and use a macro that interated
through the data source, creating a new document from the template for each
record, setting the values of the document variables to the data in the
current record, then accessed the dbf data, which I assume is specific to
data in the current record using a bit of SQL to get the appropriate data
for insert into a predetermined spot in the document before moving on to the
next record in the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"foxdev" <foxdev.RemoveThis@discussions.microsoft.com> wrote in message
news:D5B5BEF1-3C89-4828-ACE8-5AA798C6AE03@microsoft.com...
> Doug
>
> I am sorry but you are wrong. I have word doc's that used merge fields
> from
> 1 source and an inserted dbf data table from another source via oledb. I
> used
> them in 2000 and 2003. I created a headersource and a datasource doc to
> merge
> the field data. The inserted dbf updated itself when merge was executed.
> NONE
> of this works in 2007. I have the merge field part working using
> OpenDataSource but the inserted dbf will not refresh. Can you help with
> that?
>
> Thanks Chuck
>
> "Doug Robbins - Word MVP" wrote:
>
>> No, all versions of Word can only use a single flat file as a datasource.
>> To use data from more than one original source, it is necessary to
>> combine/extract the data into a single source if you want to merge it
>> into a
>> document.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "JeffreyBee" <JeffreyBee.RemoveThis@discussions.microsoft.com> wrote in message
>> news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
>> > Hello,
>> >
>> > Is it possible to use more than one data source for a mail merge in
>> > Word
>> > 2007? I know in previous versions of Word you can not however the Mail
>> > Merge
>> > Recipeits dialog box in Word 2007 seems to give the appearance that you
>> > can
>> > have more than one since the Data Source field is fairly large and has
>> > the
>> > appearance of having a scroll bar.
>> >
>> > I tried to add a second data source but was not successful.
>> >
>> > Thanks for any insight you can pass along.
>>
>>
>>

I am using automation and I missed the fact that I had accidently commented
out the execute statement. I changed the code to NOT use printout but use
destination before executing. everthing works fine except the formating. All
the autoformating does is make the displat pretty. I cannot change the
position of the data displayed as a table (4 columns with multiple rows <=
10). It always puts the table on the left margin with the cells as wide as
the widest. I use \l "2" \b "16". Is there a way to indent the table position
and set the field widths?

"Doug Robbins - Word MVP" wrote:

> Without knowing how you did it before, I do not think that I can help you,
> except to say that the way I would probably do it would be to use a
> "roll-your-own" equivalent to mail merge that used a template containing
> DOCVARIABLE fields in place of merge fields and use a macro that interated
> through the data source, creating a new document from the template for each
> record, setting the values of the document variables to the data in the
> current record, then accessed the dbf data, which I assume is specific to
> data in the current record using a bit of SQL to get the appropriate data
> for insert into a predetermined spot in the document before moving on to the
> next record in the data source.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "foxdev" <foxdev.RemoveThis@discussions.microsoft.com> wrote in message
> news:D5B5BEF1-3C89-4828-ACE8-5AA798C6AE03@microsoft.com...
> > Doug
> >
> > I am sorry but you are wrong. I have word doc's that used merge fields
> > from
> > 1 source and an inserted dbf data table from another source via oledb. I
> > used
> > them in 2000 and 2003. I created a headersource and a datasource doc to
> > merge
> > the field data. The inserted dbf updated itself when merge was executed.
> > NONE
> > of this works in 2007. I have the merge field part working using
> > OpenDataSource but the inserted dbf will not refresh. Can you help with
> > that?
> >
> > Thanks Chuck
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> No, all versions of Word can only use a single flat file as a datasource.
> >> To use data from more than one original source, it is necessary to
> >> combine/extract the data into a single source if you want to merge it
> >> into a
> >> document.
> >>
> >> --
> >> Hope this helps.
> >>
> >> Please reply to the newsgroup unless you wish to avail yourself of my
> >> services on a paid consulting basis.
> >>
> >> Doug Robbins - Word MVP
> >>
> >> "JeffreyBee" <JeffreyBee.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
> >> > Hello,
> >> >
> >> > Is it possible to use more than one data source for a mail merge in
> >> > Word
> >> > 2007? I know in previous versions of Word you can not however the Mail
> >> > Merge
> >> > Recipeits dialog box in Word 2007 seems to give the appearance that you
> >> > can
> >> > have more than one since the Data Source field is fairly large and has
> >> > the
> >> > appearance of having a scroll bar.
> >> >
> >> > I tried to add a second data source but was not successful.
> >> >
> >> > Thanks for any insight you can pass along.
> >>
> >>
> >>
>
>
>

I am not sure what you mean by \l "2" \b "16", but I would suggest that you
start with a one row table in the template that is set up the way you want
it to appear.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"foxdev" <foxdev.TakeThisOut@discussions.microsoft.com> wrote in message
news:1B7C90C3-ADFF-47F6-B0BA-B26793A8815F@microsoft.com...
>I am using automation and I missed the fact that I had accidently commented
> out the execute statement. I changed the code to NOT use printout but use
> destination before executing. everthing works fine except the formating.
> All
> the autoformating does is make the displat pretty. I cannot change the
> position of the data displayed as a table (4 columns with multiple rows <=
> 10). It always puts the table on the left margin with the cells as wide as
> the widest. I use \l "2" \b "16". Is there a way to indent the table
> position
> and set the field widths?
>
> "Doug Robbins - Word MVP" wrote:
>
>> Without knowing how you did it before, I do not think that I can help
>> you,
>> except to say that the way I would probably do it would be to use a
>> "roll-your-own" equivalent to mail merge that used a template containing
>> DOCVARIABLE fields in place of merge fields and use a macro that
>> interated
>> through the data source, creating a new document from the template for
>> each
>> record, setting the values of the document variables to the data in the
>> current record, then accessed the dbf data, which I assume is specific to
>> data in the current record using a bit of SQL to get the appropriate data
>> for insert into a predetermined spot in the document before moving on to
>> the
>> next record in the data source.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "foxdev" <foxdev.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:D5B5BEF1-3C89-4828-ACE8-5AA798C6AE03@microsoft.com...
>> > Doug
>> >
>> > I am sorry but you are wrong. I have word doc's that used merge fields
>> > from
>> > 1 source and an inserted dbf data table from another source via oledb.
>> > I
>> > used
>> > them in 2000 and 2003. I created a headersource and a datasource doc to
>> > merge
>> > the field data. The inserted dbf updated itself when merge was
>> > executed.
>> > NONE
>> > of this works in 2007. I have the merge field part working using
>> > OpenDataSource but the inserted dbf will not refresh. Can you help with
>> > that?
>> >
>> > Thanks Chuck
>> >
>> > "Doug Robbins - Word MVP" wrote:
>> >
>> >> No, all versions of Word can only use a single flat file as a
>> >> datasource.
>> >> To use data from more than one original source, it is necessary to
>> >> combine/extract the data into a single source if you want to merge it
>> >> into a
>> >> document.
>> >>
>> >> --
>> >> Hope this helps.
>> >>
>> >> Please reply to the newsgroup unless you wish to avail yourself of my
>> >> services on a paid consulting basis.
>> >>
>> >> Doug Robbins - Word MVP
>> >>
>> >> "JeffreyBee" <JeffreyBee.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> news:FCEA426B-D0BF-4D4C-953B-074A0F9BA456@microsoft.com...
>> >> > Hello,
>> >> >
>> >> > Is it possible to use more than one data source for a mail merge in
>> >> > Word
>> >> > 2007? I know in previous versions of Word you can not however the
>> >> > Mail
>> >> > Merge
>> >> > Recipeits dialog box in Word 2007 seems to give the appearance that
>> >> > you
>> >> > can
>> >> > have more than one since the Data Source field is fairly large and
>> >> > has
>> >> > the
>> >> > appearance of having a scroll bar.
>> >> >
>> >> > I tried to add a second data source but was not successful.
>> >> >
>> >> > Thanks for any insight you can pass along.
>> >>
>> >>
>> >>
>>
>>
>>