Posted 19 October 2011 - 02:13 PM
Hello, i have a excel spreadsheet, which is used for a shop which has simple stock and items
the spreadsheet, has different items, their prices and the stock amount.
it currently takes in customer details, and then selects the items.
The question is that, If i create a template on Microsoft Publisher which is a Template like a receipt
would it be possible to get the data from excel (the customer names and items ) and somehow ( this is the part i dont know or understand) paste that data onto the publisher Template and than print out that receipt.
i have a userfrom and macros recorded, on the excel spreadsheet
would it be possible to create a macro from the userfrom menu - which take the data (customer recipt ) and AUtomatically entere that data on a pre set templete reciept - on publisher
is this possible? Thank You