printing tent cards via mailmerge in word
ramapal
for. i then went into word to print the tent cards. i selected the avery tent
card template 5309 and i inserted the merge fields but word was only showing
me every other name on the tent cards. i have wasted and tried for more than
an hour to figure out how to get all the names to print but was unsuccessful.
any suggestions?
Doug Robbins - Word MVP
get one tent per sheet or two. If it is only one, make sure that you do NOT
have a <<Next Record >> field anywhere
--
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, originally posted via msnews.microsoft.com
"ramapal" <ram...@discussions.microsoft.com> wrote in message
news:7B5006AA-5D42-4BCF...@microsoft.com...
charhall
template is expecting, for some silly reason, that there is going to be a
name on each side of the tent card. If you actually did it that way, the
name on the top half would be printed upside down and the cards would be
useless. I am sure you did the same thing I did and moved the "next record"
field down to the bottom half of the mail merge.
When you executed the merge, it actually does pull in all of your records,
but every other field from your Excel file is put into a non-viewable and
non-printable space in the document. I don't pretend to understand it and
the following is not a solution, but a workaround.
After you print the first batch of every-other-card, close the merge
document and return to your template document.
Click on the Mailings tab, and then click "Edit Recipient List" to show the
Excel file in a table.
All of the fields from your Excel file will be displayed and all have a
check mark next to them. Deselect the very first line only, then click OK.
Click Finish & Merge to get your second half document, and you should have
all of the missing cards displayed now.
In the first batch you printed, you will already have the card for that
first record, and in this merge, the second record will populate the first
card and the subsequent "missing" names will fill in the rest of the file.
Confusing, I know, but it works.
All you have to do after printing is to put them back into order, if this is
important.
Keith Elliott
Once I removed the one ?Next Record? field from my 1-page tent card, I was able to MailMerge properly getting all of the names in my recipient list without any skips.
Regards,
Keith
> On Friday, March 12, 2010 1:07 PM ramapal wrote:
> i have an excel document created with a list of names to print tent cards
> for. i then went into word to print the tent cards. i selected the avery tent
> card template 5309 and i inserted the merge fields but word was only showing
> me every other name on the tent cards. i have wasted and tried for more than
> an hour to figure out how to get all the names to print but was unsuccessful.
> any suggestions?
>> On Friday, March 12, 2010 4:11 PM Doug Robbins - Word MVP wrote:
>> I have never used those cards and it is not really clear whether you just
>> get one tent per sheet or two. If it is only one, make sure that you do NOT
>> have a <<Next Record >> field anywhere
>>
>> --
>> 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, originally posted via msnews.microsoft.com
>>> On Thursday, April 22, 2010 3:13 PM charhall wrote:
>>> Hi ramapal. I have experienced this same issue and it is because the
>>> template is expecting, for some silly reason, that there is going to be a
>>> name on each side of the tent card. If you actually did it that way, the
>>> name on the top half would be printed upside down and the cards would be
>>> useless. I am sure you did the same thing I did and moved the "next record"
>>> field down to the bottom half of the mail merge.
>>>
>>> When you executed the merge, it actually does pull in all of your records,
>>> but every other field from your Excel file is put into a non-viewable and
>>> non-printable space in the document. I do not pretend to understand it and
>>> the following is not a solution, but a workaround.
>>>
>>> After you print the first batch of every-other-card, close the merge
>>> document and return to your template document.
>>>
>>> Click on the Mailings tab, and then click "Edit Recipient List" to show the
>>> Excel file in a table.
>>>
>>> All of the fields from your Excel file will be displayed and all have a
>>> check mark next to them. Deselect the very first line only, then click OK.
>>>
>>> Click Finish & Merge to get your second half document, and you should have
>>> all of the missing cards displayed now.
>>>
>>> In the first batch you printed, you will already have the card for that
>>> first record, and in this merge, the second record will populate the first
>>> card and the subsequent "missing" names will fill in the rest of the file.
>>> Confusing, I know, but it works.
>>>
>>> All you have to do after printing is to put them back into order, if this is
>>> important.
>>>
>>> "ramapal" wrote:
>>> Submitted via EggHeadCafe
>>> ASP.NET Generic Cookie Utility Class
>>> http://www.eggheadcafe.com/tutorials/aspnet/e7108c33-1cc6-48ae-9f65-cc391c8b66a7/aspnet-generic-cookie-utility-class.aspx