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 / July 2006

Tip: Looking for answers? Try searching our database.

how to use a formula in a table to allow a # in a record to be mer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer Mcdermeit - 18 Jul 2006 16:56 GMT
I have a table containing the field names and the record (second row) in
table where data is entered to be merged into a Word document.  The word
document is a photo form I made, with room for 51 photo descriptions.  Each
photo number on the form will always be different.  We are using the number
the digital camera is generating, so for instance, the photo # may be on 2000
and we take 50 shots, so it will be 2000 to 2050, on the photo form.  I would
like to have us enter the starting number (say 2000) in the table of the data
source and when it merges, have it increase by 1 at each field name in the
word photo form.  So the first photo is 2000, the next is 2001, and so forth.
I have thought of many ways to do this, such as using Next fields, but I
think the easiest way would to put a formula in the table in data source to
allow for this.  However, I don't know how.  Please help!

Thank you,
Jen
Doug Robbins - Word MVP - 18 Jul 2006 19:31 GMT
Use an Excel spreadsheet as the datasource.  It is then dead easy to have
the photo number increment by one as you go down the rows.

Signature

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

>I have a table containing the field names and the record (second row) in
> table where data is entered to be merged into a Word document.  The word
[quoted text clipped - 18 lines]
> Thank you,
> Jen

Rate this thread:






 
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.