Mail Merge Design

[Plucky]

I want to create a mail merge that would use data from two separate
datasources. Is this possible in Word?

Can i build an application in ASP.NET that will take advanatage of Microsoft
Word?

Thanks

 

[Doug Robbins - Word MVP]

No, mailmerge can only draw data from a single "flat" file. Use a query in
Access to join the two datasources and then use that query as the datasource
for a mailmerge.

I think that the answer to the second question is "technically" yes.
Whether you can do it is another question.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Joseph N.]

Use a query in
Access to join the two datasources and then use that query as
the datasource for a mailmerge.

Is there a source for further understanding what it means to "use
that query as the datasource"?

 

[Plucky]

Thanks for the reply, I tried creating an AddIn for Microsoft Word, but i am
lacking information. Does microsoft provide any sample application or addin
projects?

Thanks

 

[Patrick Heilman]

Microsoft article 211802 may help you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;211802

Patrick

 

[Doug Robbins - Word MVP]

When you go to attach a datasource to the mailmerge main document, and you
select an Access database as the source, you will be presented with a list
of the tables and queries in the database to use as the datasource.

If the list does not include the queries, from the Tools menu in Word,
select Options and then go to the General tab and check the box against the
item "Confirm conversions at open", then try using the different connection
methods that will be presented to you when you go to attach the data source.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Plucky]

I have no trouble creating a "flat file",

my problem is, i want to create a mail merge that will merge to 300 people,
and each person has a list of items from the database that need to be
displayed.

so if i outerjoin the person's record to their list of 15 items, i would
have that person's name in 15 records.

Seems like mail merges are only meant to use 1 data source...so i'm thinking
i just need to use ADODB to connect to SQL and just put the data on 300 pages
recursively.

Does this sound like a messy solution?

Thanks,
JP

 

[Doug Robbins - Word MVP]

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP