David,
As Razzak would say, here's how:
01 - In Publisher, create a label or simply create a page in the newsletter
with the mailing information (bypasses the need for a label).
02 - To set up the label or label information area. Tools/Mail and Catalog
Merge/Mail and Catalog Merge Wizard or open data source. You also have the
option to create the list in Publisher itself, but I understand you want to
manage the list in RBase, right? So pick the .csv file (comma delimited)
that will be created in RBase. Select text separator, click on comma and
uncheck First Row of Data Contains Column Headers.
03 - Tools/ Mail and Catalog Merge/Insert field. Now you can pick the data
from the left side of the screen until you have formatted the address area.
04 - Create a macro (first make sure security is off for macros)
05 - Record and name the macro. All the steps involved from opening the
Publisher File, to print merging the document, choosing a printer, number of
copies, etc... Every step will be recorded in a script file.
06 - In RBase, launch Publisher and run the macro in a single command line:
LAUNCH C:\PROGRA~1\MICROS~2\OFFICE\MSPUB.EXE /Myourmacroname
The trick here is to have the right path for the different users if they
don't happen to all use the same version of Publisher... Such as what I used
to launch word:
IF (CVAL('NAME')) = 'STAT3' THEN
LAUNCH C:\PROGRA~1\MICROS~2\OFFICE\WINWORD.EXE /morder_macro
ELSE
LAUNCH C:\PROGRA~1\MICROS~1\OFFICE\WINWORD.EXE /morder_macro
ENDIF
I'll put together some screen shots and more detailed info for you later.
I'm kinda of rushing this morning :)
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M.
> Blocker
> Sent: Friday, March 11, 2005 9: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
> >
> >
