Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2007

Tip: Looking for answers? Try searching our database.

Multiple Data Sources on a single form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dsquared - 01 May 2007 02:05 GMT
Please forgive me, but I'm new to using Mail Merge.
I was wondering if it is possible to use more than one data source in
a single document. For instance an envelope. I want to pull the
information for the recipients from one sql server table, and the
return address from another table in the same database.

Any help in pointing me in the right direction would be greatly
appreciated.
Peter Jamieson - 01 May 2007 07:37 GMT
A mailmerge can only have one data source in the sense that it is usually
understood within Word Mailmerge.

However,
a. that data source can be a view, which uses a join to bring together
related data from multiple tables and views. as long as there is something
to link each recipient with the appropriate return address you should be
able to combine the two sets of information in a view
b. if you aren't allowed to create a view in your database, you can issue
the equivalent SELECT statement from Word VBA. However, your query is
limited to around 255 or 511 characters, and that can be a significant
limitation
c. you can sometimes insert pieces of information that come from other
sources of data using DATABASE fields. However, before going down that route
you should really try out (a). If you're not familiar with SQL and views,
tell us a little bit about the structure of the tables you need to get the
data from and maybe we'll be able to make some suggestions, or you could try
asking in a more SQL-related group.

Peter Jamieson

> Please forgive me, but I'm new to using Mail Merge.
> I was wondering if it is possible to use more than one data source in
[quoted text clipped - 4 lines]
> Any help in pointing me in the right direction would be greatly
> appreciated.
dsquared - 02 May 2007 14:50 GMT
On May 1, 2:37 am, "Peter Jamieson" <p...@KillmapSpjjnet.demon.co.uk>
wrote:
> A mailmerge can only have one data source in the sense that it is usually
> understood within Word Mailmerge.
[quoted text clipped - 27 lines]
>
> - Show quoted text -

Thanks so much Peter. Creating a view worked great.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.