Deejtko Posted June 9, 2011 Posted June 9, 2011 Hello, I have a postcard I am working on that is a little more complicated than anything I have worked on in the past. Basically the data will have a code "ABCD", "ACDE", etc. (43 different codes) This code refers back to a spreadsheet that has 17 different text, images, and QR code options associated to that code. The first 13 cells are all text options for the card. The last four are associated with images and QR code Originally I was going to create a switch rule for each code and each cell but that would take forever. So my question is, aside from merging the mailing list and the code list manually in access each week is there a more streamlined option I can use with FP Desktop? Thanks for your advice in advance. Matt
Dan Korn Posted June 9, 2011 Posted June 9, 2011 It's hard to say exactly what you need to do without a little bit more detail. Can you post a sample of the input and the desired output? I think you might be able to export the spreadsheet you mentioned to a CSV file, which you can load up with ExternalDataFileEx and use it to cross-reference from the four-letter code to the associated resources. Again, though, it's hard to say without seeing the files.
Deejtko Posted June 10, 2011 Author Posted June 10, 2011 Dan, I have been messing around with your ExternalDataFileEx suggestion. It is working very nicely. Thanks for pointing me in that direction.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.