[Ryan Rawluk]

Does anybody know how to print mailing labels from client data in an FX file? I have 250 T101 slips to mail out and I would rather not use a window envelope. I either want to print mailing labels, or directly onto evelopes.

Thanks in advance.

[samhill]

I have printed labels from the Client Explorer database for my T1s. Wouldn't the FX section have the same thing in the Client Explorer?

[Dave@Intuit]

The Client Explorer (and Classic Databases) are designed more for dealing with your clients directly as opposed to printing mailing labels for slip recipients, so the database won't help with the OP's question.

As an alternative, here's an Excel workbook that we built for you that will allow you to open an FX file and generate a list of names & addresses of T4 slip recipients. You could then use that list with a mail merge to print off a bunch of labels.

A couple of notes:
The FX file CANNOT be open in ProFile when you use the workbook.
You can only use the workbook on one file at a time. If you re-run the query on a second file it will overwrite the data from the first run
In other words, save a blank copy of this workbook, and make a new copy for each FX file that you're going to use with it.
This was built using the ProFile SDK with Excel 2007 (it's a .xls file, so users of Excel 2003 ought to be able to use it too).
Feel free to open the open the Visual Basic source code to see how we did it.

We hope you find this useful!
Dave

Attached File(s)

•  2009 FX Labels.zip (26.55K)
  Number of downloads: 7

[Dave@Intuit]

My apologies to the original poster, I missed the T101 thing.

Here's an updated workbook that does the same thing for T101 slips.

 2009 FX Labels - T101.zip (19.46K)
Number of downloads: 13

Dave