Hello

I've got an excel sheet where a user can copy and paste a single line of data from an HTML table. This data is then sent by VBA code to access database. Done this way as access wouldn't accept html data in the form its written but excel does separate data in the correct way. I have no way of influencing the webpage and i didn't want to get involved in coding the access with custom clipboard. once the data is sent to the database, the form clears in readiness for the next line of data to be copied.

so i have about 10 fields of data. what i want to do is produce a label with only 3 of the fields printed to it. I need to produce 4 labels that are an exact copy.The label size is 7.2 x 3.6cm

I already have defined strings to store data for each field before a sqlinsert into access

what would be the best way of doing this?

many thanks