David, I've reviewed my MS pubisher 2000 for what to do for address labeling!
The feature that MS Word has is included in MS Publisher! It is the mail merge feature! You can connect to several external sources but it is not ODBC. Here is a list of what type of files: Use a data source created in another program Publisher can recognize data source information created in any of the following file formats: Microsoft Access (all versions up to and including Office 2000) Microsoft Excel versions 3.0, 4.0, 5.0, 7.0, and 8.0 Microsoft FoxPro 2.0, 2.5, and 2.6 Microsoft Outlook (all versions up to and including Outlook 2000) Microsoft Word tables or merge data documents Microsoft Works for MS-DOS 3.0 (if database contains no formulas) Microsoft Works for Windows 2.0, 3.0, and 4.x (if database contains no formulas) dBase III, IV, and V ASCII text files (except for fixed-field width files) Hope this helps! Best regards, Oma Cox -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Friday, March 11, 2005 7:47 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: R:Base and MS Publisher Claudine Thanks for your offer to help! 1. Please DO send me the steps in Publisher 2. Please say more about "with a macro you could automatically print the labels from within R:Base". Remember what we want to do is print a NEWSLETTER from Publisher that at the same time prints out addresses. Can you specify the steps within R:Base and within Publisher to do what you're describing. It would be awesome! David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, March 11, 2005 10:21 AM Subject: [RBG7-L] - RE: R:Base and MS Publisher > David, > > I forgot to mention that with a macro you could automatically print > the labels from within RBase. I used to do it with Word. > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David > > M. Blocker > > Sent: Friday, March 11, 2005 7:50 AM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - R:Base and MS Publisher > > > > Here's an interesting problem. I have a potential client currently using > > Access and I'm going to do a demo of R:Base for them in 10 days. I'd > > LOVE > > to woo them away. They use Publisher, which I'm not familiar with, > > to print a newsletter. They have names and addresses of those > > getting the newsletter > > in Access. Currently, they produce the newsletter with 3 steps: > > > > 1. Print the newsletter > > 2. Print mailing labels from Access > > 3. Stick the labels on the newsletters! > > > > They have been told by an Access person that it's possible to link > > Publisher with Access and do all 3 steps at once, though they > > haven't done it yet. Has anyone ever done this with R:Base and > > Publisher, or can you steer me in > > the right direction. A simple demo of this when I go in would I think get > > us > > a convert.... > > > > David > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > >
