G Guest Nov 28, 2005 #1 I would like to create raffle tickets in Excel. How can I do this? I know it is possible but I haven't a clue on where to begin.
I would like to create raffle tickets in Excel. How can I do this? I know it is possible but I haven't a clue on where to begin.
G Gord Dibben Nov 28, 2005 #2 jt That would all depend upon how the ticket data is laid out and you give very little detail. Printing these directly from Excel can be a pain due to formatting. I do up a lot of numbered tickets for a couple of associations I belong to. I set up my ticket data in Excel in columns with a column for numbers then I use Word Mailmerge to print the tickets. Printing labels or tickets from Excel is trial and error but can be done. Word does a fine job because it is designed for that type of operation. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm And a training tutorial for creating envelopes and labels. The labels will be your raffle tickets. http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033 Gord Dibben Excel MVP
jt That would all depend upon how the ticket data is laid out and you give very little detail. Printing these directly from Excel can be a pain due to formatting. I do up a lot of numbered tickets for a couple of associations I belong to. I set up my ticket data in Excel in columns with a column for numbers then I use Word Mailmerge to print the tickets. Printing labels or tickets from Excel is trial and error but can be done. Word does a fine job because it is designed for that type of operation. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm And a training tutorial for creating envelopes and labels. The labels will be your raffle tickets. http://office.microsoft.com/training/training.aspx?AssetID=RC010390291033 Gord Dibben Excel MVP