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 / December 2003

Tip: Looking for answers? Try searching our database.

Help with Merge Conditional Number of Records to the Same Page

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian Collie - 11 Dec 2003 15:51 GMT
I have created the Sample Data File and the Document in MS Knowlede Base
Article 105888 and I do not get the results as shown in the article. My
results are shown below. What am I doing wrong?  Can anyone provide me with
a document that works like the example in the Knowlege Base article? Thanks.

Employee         Project

John Doe                      4578jP

t4578jP

t4578jP

t4578jP

t4578j

--- Page Break ---
Employee         Project

John Doe                      86785xP

t86785xP

t86785xP

t86785xP

t86785x

--- Page Break ---
Employee         Project
John Doe                      543p

--- Page Break ---
Employee         Project

Jane Doe                      87xP

t87xP

t87xP

t87xP

t87x

--- Page Break ---
Employee         Project

Jane Doe                      89976m

--- Page Break ---
Employee         Project

Sam Smith                    7897rP

t7897rP

t7897rP

t7897rP

t7897r

--- Page Break ---
Employee         Project

Sam Smith                    857tP

t857tP

t857tP

t857tP

t857t

--- Page Break ---
Employee         Project

Sam Smith                    78974xP

t78974xP

t78974xP

t78974xP

t78974x

--- Page Break ---
Employee         Project

Sam Smith                    7868p
Peter Jamieson - 11 Dec 2003 17:45 GMT
I've e-mailed you with some sample docs.

--
Peter Jamieson - Word MVP

> I have created the Sample Data File and the Document in MS Knowlede Base
> Article 105888 and I do not get the results as shown in the article. My
[quoted text clipped - 91 lines]
>
> Sam Smith                    7868p
Peter Jamieson - 12 Dec 2003 18:37 GMT
...but my message was returned undelivered.

e-mail me with an address that works if you still want the example docs.

--
Peter Jamieson - Word MVP

> I've e-mailed you with some sample docs.
>
[quoted text clipped - 98 lines]
> >
> > Sam Smith                    7868p
Badger - 13 Dec 2003 14:46 GMT
Brian,

Personally I have found KB181730 to be of more use than 105888 when trying
to sort out merges like this.
If you need any more help after reading Peter's examples, let me know.
Have successfully merged a few projects similar to yours.

Paul

> ...but my message was returned undelivered.
>
[quoted text clipped - 105 lines]
> > >
> > > Sam Smith                    7868p
Brian Collie - 15 Dec 2003 15:15 GMT
Thanks for the response Paul. I will look at KB 181730 and contact you after
I receive Peter's samples if I need more help.

Brian

> Brian,
>
[quoted text clipped - 116 lines]
> > > >
> > > > Sam Smith                    7868p
Brian Collie - 15 Dec 2003 15:15 GMT
Peter I sent you two messages with my correct address. I'm sorry that you
did not get them. My email address is  briancspam@colliecpa.com . Please
remove "spam" from the address.

Thanks,

Brian

> ...but my message was returned undelivered.
>
[quoted text clipped - 105 lines]
> > >
> > > Sam Smith                    7868p
Peter Jamieson - 16 Dec 2003 03:17 GMT
OK, I re-sent the sample .docs a few hours ago.

--
Peter Jamieson - Word MVP

> Peter I sent you two messages with my correct address. I'm sorry that you
> did not get them. My email address is  briancspam@colliecpa.com . Please
[quoted text clipped - 115 lines]
> > > >
> > > > Sam Smith                    7868p
Brian Collie - 16 Dec 2003 15:58 GMT
Thanks for the help Peter. I received an email from Paul Badger with the
code that does what I need. He used KB 294686 to create a merge that works
for me.

Thanks again,

Brian

> OK, I re-sent the sample .docs a few hours ago.
>
> --
> Peter Jamieson - Word MVP
Brian Collie - 15 Dec 2003 21:44 GMT
I don't know if it is possible to do what I am trying to do? I have an Excel
spreadsheet like this:

     Signer         Taxpayer             Number   Description
Year  Check
     Signer 1     Taxpayer 1           275          Texas State Franchise
Tax Return                    2004      1
     Signer 2     Taxpayer 2           4471        U.S. Individual Federal
Income Tax  Return     2003     1
     Signer 3     Taxpayer 3           2860        Texas State Franchise
Tax Return                    2004
     Signer 3     Taxpayer 3           2860        U.S. Partnership Federal
Income Tax Return    2003
     Signer 3     Taxpayer 4           2863        U.S. Partnership Federal
Income Tax Return    2003
     Signer 3     Taxpayer 5           2864        U.S. Partnership Federal
Income Tax Return     2003    1
     Signer 4     Taxpayer 6            305         U.S. Corporation
Federal Income Tax Return   2003
     Signer 4     Taxpayer 6            305         Texas State Franchise
Tax Return                     2004     1
     Signer 4     Taxpayer 7           1000        U.S. Individual Federal
Income Tax Return       2003
     Signer 5     Taxpayer 8            775         U.S. Individual Federal
Income Tax Return       2003     1

I want to create a Word merge document that will put each signer on a
seperate page like this:

Taxpayer 1        275        Texas State Franchise Tax Return
2004

---Page Break---

Taxpayer 2        4471        U.S. Individual Federal Income Tax Return
2003

---Page Break---

Taxpayer 3        2860        Texas State Franchise Tax Return
2004
Taxpayer 3        2860        U.S. Partnership Federal Income Tax Return
2003
Taxpayer 4        2863        U.S. Partnership Federal Income Tax Return
2003
Taxpayer 5        2864        U.S. Partnership Federal Income Tax Return
2003

---Page Break---

Taxpayer 6        305        U.S. Corporation Federal Income Tax Return
2004
Taxpayer 6        305        Texas State Franchise Tax Return
2004
Taxpayer 7        1000      U.S. Individual Federal Income Tax Return
2003

---Page Break---

Taxpayer 8        775        U.S. Individual Federal Income Tax Return
2003

Is this possible?

Thanks,

Brian
 
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.