Forum Home
Press F1
 
Thread ID: 81959 2007-08-12 03:25:00 Word mail merge yorkshirekid (9033) Press F1
Post ID Timestamp Content User
579801 2007-08-12 03:25:00 In Word, I've made a ticket. It has space for two fields; date and seat. In Word I have made a database [table] with the dates and seat numbers. I am trying to merge both fields into the ticket. I want only one copy of each ticket per page and I have room for 8 tickets per page. So page one might have 'Saturday 1st' and tickets numbered 1-8. Page two would have 'Saturday 1st' and tickets numbered 9-16. Page three would follow suit until a second date was chosen.

I can't figure out if I need a mail merge, a label merge or an envelope merge and I've tried them all. Can someone give me a step-by-step walk through please. Googled to no specific avail.
yorkshirekid (9033)
579802 2007-08-12 03:45:00 depends on what size you want to print.

Adjust page size and margins to suit what you need to print.

When it comes time to print set your advanced printer settings to that size also.

If you started out by using the Merge wizard there will be an Insert Field option at the top. Position your cursor and insert the field you need.
Bantu (52)
579803 2007-08-12 03:53:00 Sorry Bantu bit this isn't helpful. Size is irrelevant and I did say there are 8 tickets per page. I can get the field in the correct place but I want EACH ticket on the page to register a new seat number with the SAME date. I can't do this part. I can get it working for 1 ticket but thats all. How do I make the 'next record' work? Thanks yorkshirekid (9033)
579804 2007-08-12 04:57:00 Hi Yorkie.
Looks like a label mail merge might suit. Re your little database, how many dates and how many numbered tickets per date (approx)?
Scouse (83)
579805 2007-08-12 05:51:00 I think all you need to do is use the Insert Word Field function (from the Mail Merge toolbar) and select Next Record.

The Next Record option should be placed before any fields selected from your data base for your second and subsequent records

Should look something like this

Ticket«Next Record»«TicketNo» where Ticket is descriptive Text and TicketNo is the field from your database

Hope this helps
TeejayR (4271)
579806 2007-08-12 10:26:00 Thanks guys. Got it sorted. I was trying to insert fields within a text box and it made it go all wonky. I just re wrote the whole thing and it was fine. But, your support did help - it made me focus.

Cheers:thumbs:
yorkshirekid (9033)
1