Hi, I've used both Excel and Access in the past but it's been a while. I work for a hotel in the admin department. We have these confirmation of booking letters that we send out every time someone makes a reservation. It's irritating going through each letter on word and changing the details for each reservation, a lot of the time something goes wrong and you get a mix up of dates and prices and confirmation numbers. I wanted to use access to create some kind of form that would let me type in all the vital information and dump it right onto the word doc (or similar printable document) but access isn't istalled on the machines here! I figure I can do it in Excel but I want to get a few tips first. Basically I want a first page (or even better, a pop-up box) that says Name, Arrival Date, Departure Date, Confirmation number with little boxes to type everything into, then a little ok button or something that puts all the information entered into all the little boxes onto the existing letter in the correct places ready to print (My use of technical terms amazes even me!)
Any advice on this would be great. I'm not 100% where to start!
Thanks
WIll
Bookmarks