Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jason G
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is there
a way to insure that the customers name on the front will be married to the
appropirate information on the back without printing each individual card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

Where do you have the datasource? The answer to that question will dictate
how you go about arranging this.

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

"Jason G" Jason wrote in message
...
I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is
there
a way to insure that the customers name on the front will be married to
the
appropirate information on the back without printing each individual card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)




  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jason G
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

Well, the data comes to us in a file that is processed in Unix. Once
processed it is send to a database where it is retrieved by a print operator
thorough Xerox's Print Select. The file, when you look at it, is comma
delimited. So one row will have one customer with all of thier information
side by side seperated by commas. Now that I think about it, I'm not sure
that we can do this the way we planned. If the data has the customers
information like this; name, address1, address2, address3, type 10a, type
10b; name, address1, address2, address3, type 10a, type 10b; etc....

Then there is no way to split the data front/back unless it is done one page
at a time. Is there a way to create just one postcard with merge information
on it, duplex it, and the set it to print in groups of 4 where the frames are
linked front/back?
--
Print SpecialistAffinion Group


"Doug Robbins - Word MVP" wrote:

Where do you have the datasource? The answer to that question will dictate
how you go about arranging this.

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

"Jason G" Jason wrote in message
...
I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is
there
a way to insure that the customers name on the front will be married to
the
appropirate information on the back without printing each individual card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)





  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

To do what you want to do, you will need to open the comma delimited file in
Excel, then add a column of sequential numbers, and in the adjoining column
enter the following formula (which in this case assumes that the sequential
numbers are in column A

=IF(MOD(A1,2)=1,A1+1,A1-1)

When you copy that down, you will have the following two columns of numbers

1 2
2 1
3 4
4 3
5 6
6 5
7 8
8 7

etc.

You need to use copypaste special values, to convert the formula to values,
then sort by the second column and use the spreadsheet in that format to
merge the second side.

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

"Jason G" wrote in message
...
Well, the data comes to us in a file that is processed in Unix. Once
processed it is send to a database where it is retrieved by a print
operator
thorough Xerox's Print Select. The file, when you look at it, is comma
delimited. So one row will have one customer with all of thier information
side by side seperated by commas. Now that I think about it, I'm not sure
that we can do this the way we planned. If the data has the customers
information like this; name, address1, address2, address3, type 10a, type
10b; name, address1, address2, address3, type 10a, type 10b; etc....

Then there is no way to split the data front/back unless it is done one
page
at a time. Is there a way to create just one postcard with merge
information
on it, duplex it, and the set it to print in groups of 4 where the frames
are
linked front/back?
--
Print SpecialistAffinion Group


"Doug Robbins - Word MVP" wrote:

Where do you have the datasource? The answer to that question will
dictate
how you go about arranging this.

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

"Jason G" Jason wrote in message
...
I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is
there
a way to insure that the customers name on the front will be married to
the
appropirate information on the back without printing each individual
card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)







  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jason G
 
Posts: n/a
Default Mail Merge on 4up Postcard front/back

Thanks for your help. Due to deadlines we decided to go another route with
this. I appreciate the fast response to my query.

Thanks again.
--
Print SpecialistAffinion Group


"Doug Robbins - Word MVP" wrote:

To do what you want to do, you will need to open the comma delimited file in
Excel, then add a column of sequential numbers, and in the adjoining column
enter the following formula (which in this case assumes that the sequential
numbers are in column A

=IF(MOD(A1,2)=1,A1+1,A1-1)

When you copy that down, you will have the following two columns of numbers

1 2
2 1
3 4
4 3
5 6
6 5
7 8
8 7

etc.

You need to use copypaste special values, to convert the formula to values,
then sort by the second column and use the spreadsheet in that format to
merge the second side.

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

"Jason G" wrote in message
...
Well, the data comes to us in a file that is processed in Unix. Once
processed it is send to a database where it is retrieved by a print
operator
thorough Xerox's Print Select. The file, when you look at it, is comma
delimited. So one row will have one customer with all of thier information
side by side seperated by commas. Now that I think about it, I'm not sure
that we can do this the way we planned. If the data has the customers
information like this; name, address1, address2, address3, type 10a, type
10b; name, address1, address2, address3, type 10a, type 10b; etc....

Then there is no way to split the data front/back unless it is done one
page
at a time. Is there a way to create just one postcard with merge
information
on it, duplex it, and the set it to print in groups of 4 where the frames
are
linked front/back?
--
Print SpecialistAffinion Group


"Doug Robbins - Word MVP" wrote:

Where do you have the datasource? The answer to that question will
dictate
how you go about arranging this.

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

"Jason G" Jason wrote in message
...
I have a slightly different situation than previously posted. I have a
postcard, 4up, that has merge information on the back of each card. Is
there
a way to insure that the customers name on the front will be married to
the
appropirate information on the back without printing each individual
card
seperately? (ex. Back 4 will have Type10 merge fields for each card for
differing member fee information for each customer.)








Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Losing Data Scott May Mailmerge 1 November 1st 05 11:03 PM
Mail Merge - Parameter prompts twice... TL Mailmerge 6 June 17th 05 02:58 PM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


All times are GMT +1. The time now is 07:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"