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

Tip: Looking for answers? Try searching our database.

Mail merge new record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jackieblue - 30 Oct 2007 10:06 GMT
Hello,
I am not sure I really know how/when/whether to use New Record.
I have a spreadsheet with lists of of electricians' drawings - which are
batched.
I would like to do a mail merge in word into a table but so that the new
record happens only when the batch number changes. For example batch 1 might
have 10 drawings, batch 2 only 8.
Ideally I would like to merge into a word table, with a new table starting
every time there is a new batch number.
If that's not possible I would at least like to filter and merge only 1
batch at a time. Because of the way I am setting my table up, it is merging,
but starting a new single line table for every apartment number as opposed to
a 10 line table when the batch number changes.
What am I doing wrong ?
I hope my explanation is clear enough for somebody to be able to advise me.
Many thanks. Jackie
Peter Jamieson - 30 Oct 2007 17:51 GMT
Word isn't really designed to do this (you might be better off trying to do
it in Access, for example), but a starting point for doing this
without VBA is the MS Knowledgebase article at

http://support.microsoft.com/kb/211303

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hello,
> I am not sure I really know how/when/whether to use New Record.
[quoted text clipped - 16 lines]
> me.
> Many thanks. Jackie
Jackieblue - 31 Oct 2007 09:29 GMT
Thank you very much.
It looks complicated but I'm sure once I read it properly and try to use it
things will become clearer.
Thanks again.

> Word isn't really designed to do this (you might be better off trying to do
> it in Access, for example), but a starting point for doing this
[quoted text clipped - 22 lines]
> > me.
> > Many thanks. Jackie
Peter Jamieson - 31 Oct 2007 13:45 GMT
For various other perspectives on this problem, search Google Groups for
recent messages containing

Peter Jamieson MERGESEQ

There is still a rather complex example at

http://suzleigh.com/MERGE.aspx

but I don't know how long she will leave it up there. (I keep meaning to
progress my own samples but am not quite ready yet!)

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Thank you very much.
> It looks complicated but I'm sure once I read it properly and try to use
[quoted text clipped - 33 lines]
>> > me.
>> > Many thanks. Jackie
 
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.