Jump to content

CathyK

Members
  • Content count

    6
  • Joined

  • Last visited

Community Reputation

0 Neutral

About CathyK

  • Rank
    novice
  1. CathyK

    Emailing as Plain Text

    I have a database (letter layout) that is linked to an Excel file. In this Excel file are "Email," "Name," etc. columns. Is it possible to create a script (I think this is what I need) so that it will send the letters (using the "Email" column) as plain text in the email message area and not as an attachment. I have Novell Groupwise but can get Microsoft Outlook if I can't use Groupwise to email the letters. I just started learning Filemaker so if someone could show me all of the script steps involved then I'd appreciate it. Thanks
  2. CathyK

    Linked OLE Objects

    I decided to create a layout per Word document so right now in a filemaker database, I have the ART document inserted as an object for one layout, COMM document inserted as an object in another layout, BIOL document inserted as an object in another layout (will be creating 6 more layouts for 6 more Word documents). I still don't understand how to create the database so that on the ART layout only records with ART in the Excel field are retrieved, etc. All records are showing on all layouts no matter what is in the Excel file field. Example of what I have in the Excel test file: Name: Area: JOHN DOE ART JANE DOE COMM BOB DOE ART MARY DOE BIOL All four of these records are showing on the ART layout, COMM layout and BIOL layout. Sorry but filemaker really confuses me.
  3. CathyK

    Linked OLE Objects

    1. I was hoping I would only need to create one layout but oh well, guess I'll create nine layouts. I work with another program (can't use it because of other problems) and was hoping filemaker would be able to do the same thing: if field=ART then linked "ART document" else if field=COMM then linked "COMM document" else '' 2. If a linked document is changed by a user and the changes remove or add lines of text to it then does the line spacing between the linked document and text on the Filemaker layout remain. Example, ==== linked document includes only one line of text This part is just typed on the filemaker layout ==== If the linked document gets changed and now includes two lines will the letter look like: linked document now includes two lines of text This part is just typed on the filemaker layout [color:"red"]or will the line spacing between the linked document and text remain so still look like linked document now includes two lines of text This part is just typed on the filemaker layout =================== Thanks for your help.
  4. CathyK

    Linked OLE Objects

    Hi John, The documents are controlled by different users so if the user decides to make a change in their document then I want the filemaker database letter to automatically update with the change. Thanks
  5. CathyK

    Linked OLE Objects

    Hi Kenneth, I'm so new to Filemaker that I don't even really know how to work with a container (I just see it as one of the options when you are defining a field). There are Word documents (OLE objects) that need to change and then text above and below the documents that will be in every record. Hopefully, I can show what I'm typing to accomplish in the example below =================================================== Wednesday, December 10, 2003 Dear John, - The "First Name" is being imported from an Excel file Welcome to the program, etc. - This welcome part needs to be included in every record so I was just going to type it in as text. Thank you for enrolling, etc. - This part will be the OLE object and needs to change depending on another field in the Excel file (if field = ART then the ART word document should show on the record, if field = COMM then the COMM word document should show on the record, etc.) If you have any questions, please call, etc. - This last part needs to be included in every record so I was just going to type it in also just as text. =================================================== Thanks for your help.
  6. I'm a newbie to Filemaker and have no clue at all how to complete the following (or a lot of things): 1. I have different Word documents and depending on the data in a field (being imported from an Excel file) will determine which Word document should appear on a record (i.e. if the field equals ART then the document concerning ART should appear on a record, if the field equals COMM then the document concerning COMM should appear on the record, etc.). The documents could change so I need to make them linked OLE objects. 2. There will be text after the linked information but what happens to the line spacing between the linked information and text if the linked information is changed (more or less lines are included). Does the line spacing between the linked information and text adjust? All help would be appreciated (especially if you could explain all of the steps involved in detail). Thanks
×

Important Information

By using this site, you agree to our Terms of Use.