Word 2007 Mail Merge Data Source

I would guess you are using an InsertDatabase from VBA. The problem with
this is that your control over the layout of the table is very limited. You
/might/ be able to preserve some formatting by using a DATABASE field
instead, with the \*Mergeformat switch, but in my experience it is unlikely
to be reliable and column widths etc. will change from page to page.

For this kind of application I think you have to think in terms of
outputting to a new document, then using VBA to format the tables after the
merge.
--
Peter Jamieson
http://tips.pjmsn.me.uk

"foxdev" <foxdev.RemoveThis@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.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.
>> >>
>> >>
>> >>
>>
>>
>>