Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I mail merge to a template of four landscape postcards?
I have a postcard template and need to mail merge the addresses on the front
and and individualized message on the back. We cannot separate the postcards and print them individually; they have to remain 8 1/2 x 11. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I mail merge to a template of four landscape postcards?
You need to get your data source into an Excel spreadsheet and 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 "Earlene" wrote in message ... I have a postcard template and need to mail merge the addresses on the front and and individualized message on the back. We cannot separate the postcards and print them individually; they have to remain 8 1/2 x 11. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge with attachments | Mailmerge | |||
Mail Merge using template from Word 97 | Mailmerge | |||
mail merge an access db into a post card template using 4 postard. | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help |