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 / April 2007

Tip: Looking for answers? Try searching our database.

Advanced Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hootie - 10 Apr 2007 13:20 GMT
I have an excel 2003 spreadsheet containing supplier open order information
and I am trying to create a mail merge through word 2003 that will populate a
table with all outstanding orders within a certain date range and then email
the merged document out through outlook 2003.

I have created a 2 row table, first row is table headers, and want the other
rows to self-populate according to the number of open orders still
outstanding with a supplier. I can get the merge to show only one line at a
time but no more. Is there anybody out there who can solve this for me or who
is experiencing a similar problem.

If not, does anybody know of a software or word/office 2003 add in that
could solve this problem.
Peter Jamieson - 10 Apr 2007 14:11 GMT
If you use a catalog merge (directory merge in Word 2002 and later, unless
you're starting from Outlook), then delete the row of headers, do the merge
to an output document and you should see the basis of the result you need.
(i.e. don't just preview the merge or you will only see one row at a time).
Don't put any { NEXT } / <<Next record>> fields in.

However, in that case you would have to re-insert the header row manually or
presumably in this case, using code. You might be able to keep the header in
a separate file and re-insert it as long as the column widths were fixed.

But you could also use a DATABASE field to insert the contents of the Excel
sheet - use Word Tools|Customize to enable the Dtabase toolbar and have a
look at inserting the data that way. You have less control over the table
layout, but if you are using VBA to perform the whole process you could use
it to format the table how you want. Or you can use Word's InsertDatabase
method.

If you need it, for a discussion of format issues when  getting data from
Excel during a merge or when inserting a database, see
http://tips.pjmsn.me.uk/t0003.htm

Peter Jamieson

>I have an excel 2003 spreadsheet containing supplier open order information
> and I am trying to create a mail merge through word 2003 that will
[quoted text clipped - 14 lines]
> If not, does anybody know of a software or word/office 2003 add in that
> could solve this problem.
 
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.