Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
I've finaly figured out an effecient way to make flashcards except one
problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
See the following page of fellow MVP Graham Mayor's website from which you
can download an Addin that he and I collaborated on that will enable you to do what you want: http://www.gmayor.com/duplex_merge_data.htm -- 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 "Alan" wrote in message ... I've finaly figured out an effecient way to make flashcards except one problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
Thank you very much Doug. I'm sure this will work if I can get the "duplex"
macro to show up as a selection. I believe I have to save the file in a particular place to achieve this. Also, any thoughts on how to solve this problem by making an adjustment on excel. It seems possible. At first I thought shifting column "B" down by one cell would cause the desired effect. That is not the solution but I think one exists. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website from which you can download an Addin that he and I collaborated on that will enable you to do what you want: http://www.gmayor.com/duplex_merge_data.htm -- 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 "Alan" wrote in message ... I've finaly figured out an effecient way to make flashcards except one problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
The add-in template should be stored in the Word startup folder (tools
options file locations startup) for it always to be available. If you want it available only occasionally, put it in any folder and add it to the list in tools templates and add-ins, then make sure it is checked when you want to use it. Macros must be enabled for the macros to be available. I can't believe I didn't mention that on the web page - that's another job for today -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Alan wrote: Thank you very much Doug. I'm sure this will work if I can get the "duplex" macro to show up as a selection. I believe I have to save the file in a particular place to achieve this. Also, any thoughts on how to solve this problem by making an adjustment on excel. It seems possible. At first I thought shifting column "B" down by one cell would cause the desired effect. That is not the solution but I think one exists. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website from which you can download an Addin that he and I collaborated on that will enable you to do what you want: http://www.gmayor.com/duplex_merge_data.htm -- 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 "Alan" wrote in message ... I've finaly figured out an effecient way to make flashcards except one problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
Thanks Graham. You did include those instructions on the provided link. I
saved and unzipped the "duplex" macro in the designated folder and still don't see it. "Graham Mayor" wrote: The add-in template should be stored in the Word startup folder (tools options file locations startup) for it always to be available. If you want it available only occasionally, put it in any folder and add it to the list in tools templates and add-ins, then make sure it is checked when you want to use it. Macros must be enabled for the macros to be available. I can't believe I didn't mention that on the web page - that's another job for today -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Alan wrote: Thank you very much Doug. I'm sure this will work if I can get the "duplex" macro to show up as a selection. I believe I have to save the file in a particular place to achieve this. Also, any thoughts on how to solve this problem by making an adjustment on excel. It seems possible. At first I thought shifting column "B" down by one cell would cause the desired effect. That is not the solution but I think one exists. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website from which you can download an Addin that he and I collaborated on that will enable you to do what you want: http://www.gmayor.com/duplex_merge_data.htm -- 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 "Alan" wrote in message ... I've finaly figured out an effecient way to make flashcards except one problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge Invert columns for flashcards
Do you have macro security set to Medium and to trust installed templates
and add-ins? Restart Word (and Outlook if you use Word as Outlook's editor). Does it appear in tools templates and add-ins and is it checked? Do you have a toolbar (currently unchecked) called Duplex PostCards Data? Do you have a macro listed in tools macro macros called DuplexData? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Alan wrote: Thanks Graham. You did include those instructions on the provided link. I saved and unzipped the "duplex" macro in the designated folder and still don't see it. "Graham Mayor" wrote: The add-in template should be stored in the Word startup folder (tools options file locations startup) for it always to be available. If you want it available only occasionally, put it in any folder and add it to the list in tools templates and add-ins, then make sure it is checked when you want to use it. Macros must be enabled for the macros to be available. I can't believe I didn't mention that on the web page - that's another job for today -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Alan wrote: Thank you very much Doug. I'm sure this will work if I can get the "duplex" macro to show up as a selection. I believe I have to save the file in a particular place to achieve this. Also, any thoughts on how to solve this problem by making an adjustment on excel. It seems possible. At first I thought shifting column "B" down by one cell would cause the desired effect. That is not the solution but I think one exists. "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Graham Mayor's website from which you can download an Addin that he and I collaborated on that will enable you to do what you want: http://www.gmayor.com/duplex_merge_data.htm -- 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 "Alan" wrote in message ... I've finaly figured out an effecient way to make flashcards except one problem. In an excel file I have two columns, one for each side of the flash card. I then do a mail merge with a small size label ie. name badge (2.1" by 3.5") which creates 8 boxes per page. The merge fills each box with an entry from a specefied column in the excel file. Now the fronts of the flashcards are prepared. Next step, repeat process with the entries fron the second column and then refeed the paper so the backs are printed with the appropriate data. I hope that makes sense. Now the problem...I need to invert the columns for the backs of the flashcards to have the correct data. If not the backs of the flash cards end up with the wrong information. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you create flashcards to memorize something? | New Users | |||
Using mailmerge, print to 4 columns, 2 at a time | Mailmerge | |||
Mailmerge with Excel spreadsheet switches columns to display | Mailmerge | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge | |||
How do I create Flashcards? | Microsoft Word Help |