Jump to content

CandiceCM

Members
  • Content count

    17
  • Joined

  • Last visited

Community Reputation

0 Neutral

About CandiceCM

  • Rank
    member
  • Birthday March 12

Profile Information

  • Gender
    Female
  • Location
    Baltimore, MD
  1. CandiceCM

    Editing with IWP

    Thank you!
  2. CandiceCM

    Editing with IWP

    Hi, I've created a database and am about to give access to it to individuals within my company for viewing. I want them to be able to update the records within it but I don't want them to be able to delete any records. Is there a way to allow them to edit the database but not delete? I think I read something about this when I was teaching myself how to use the program but can't remember where I read it.
  3. CandiceCM

    Merge Letter Help

    Thank you LaRetta, I made the changes you suggested and it is now doing what I want. I had to remove "Show all Records" as it was sending the email to all of my 1100 contacts. Once I took that out it worked perfectly. Thanks for pointing out that checkbox. Totally overlooked it. You saved me! Thanks again for making my life easier!
  4. CandiceCM

    Merge Letter Help

    I got it to work without making any changes to my script. I was performing a find and trying to send to only my found set. Once I changed to "multiple emails (one for each found set)" it did what I wanted it to do. I'm going to make a copy make the changes you suggested and see if I still get the same result or do you think I should leave it alone since it is working?
  5. CandiceCM

    Merge Letter Help

    Hi LaRetta, Thanks for the advice on backing up. With the crazy auto saving in FM I usually make a copy of my database every morning with a new date at the end in-case I screw something up. Do you have any advice on my looping problem? Candice
  6. CandiceCM

    Merge Letter Help

    Thank you everyone for your help. I'm still not quite getting the result I want. Now I can get it to only send to one person but it is only sending one email. Not to everyone in my found set. I'm sure I did something wrong in my loop command as this is the first script I've ever written in FM. I could not find a command that said "Got to Record/Reques tNext, Exit after last". Here is what I did: Set Error Capture [ On ] Freeze Window Go to Layout [ “Ceratech Materials Letter” (Concrete Contractors) ] Insert Text [ ] [ Select ] Set Field [ ] Go to Record/Request/Page [ First ] Loop Send Mail [ Send via E-mail Client; To: Concrete Contractors::Work Email (collect addresses); Subject: "CERATECH Materials"; Message: "Dear " & Concrete Contractors::First& ":¶¶" &"I understand you are involved with the "& Concrete Contractors::Project Name &" project. We would like to introduce our technology to you which provides 2x-4x the durability of typical Portland cement concrete at virtually the same cost. Additionally, if you have any secondary containment applications, we have materials that are extremely resistant to most chemicals without the need for coatings. I have included links to information for your review and if you would like to learn more about our technology and how we can decrease your maintenance costs and increase the lifespan of your concrete, please let me know. " &¶&¶ &"http://www.ceratechinc.com/Content/PDFs/CERATECH-Industrial-Cement-Solutions-6.12.pdf " &¶&¶ &"http://www.ceratechinc.com/Content/PDFs/KEMROK-BULK-Cement-Data-Sheet.pdf " &¶&¶ &"http://www.ceratechinc.com/Content/PDFs/ekkomaxx-BULK-Cement-Data-Sheet.pdf " &¶&¶ &"Sincerely, " &¶ &"Maja Gray " &¶ &"CeraTech, Inc. " &¶ &"1500 N. Beauregard St., Ste. 320 " &¶ &"Alexandria, VA 22311 " &¶ &"Tel: 703-894-1130 x24 " &¶ &"Fax: 703-894-1068 " &¶ ] Go to Record/Request/Page [ Next ] Exit Script [ Result: Last ( Concrete Contractors::Work Email ) ] End Loop What am I doing wrong????? Once I learn this I will never forget. I appreciate your help.
  7. CandiceCM

    Merge Letter Help

    Lee and Beverly, thank you so much for your advice. Here is a copy of my script: Send Ceratech Letter by Email Set Error Capture [ On ] Freeze Window Go to Layout [ “Ceratech Materials Letter” (Concrete Contractors) ] Insert Text [ ] [ Select ] Set Field [ ] Send Mail [ Send via E-mail Client; To: Concrete Contractors::Work Email (collect addresses); Subject: "CERATECH Materials"; Message: "Dear " & Concrete Contractors::First& ":¶¶" &"I understand you are involved with the "& Concrete Contractors::Project Name &" project. We would like to introduce our technology to you which provides 2x-4x the durability of typical Portland cement concrete at virtually the same cost. Additionally, if you have any secondary containment applications, we have materials that are extremely resistant to most chemicals without the need for coatings. I have included links to information for your review and if you would like to learn more about our technology and how we can decrease your maintenance costs and increase the lifespan of your concrete, please let me know. " &¶&¶ &"http://www.ceratechi...utions-6.12.pdf " &¶&¶ &"http://www.ceratechi...-Data-Sheet.pdf " &¶&¶ &"http://www.ceratechi...-Data-Sheet.pdf " &¶&¶ &"Sincerely, " &¶ &"Maja Gray " &¶ &"CeraTech, Inc. " &¶ &"1500 N. Beauregard St., Ste. 320 " &¶ &"Alexandria, VA 22311 " &¶ &"Tel: 703-894-1130 x24 " &¶ &"Fax: 703-894-1068 " &¶; Attachment: “$PATH” ] I had to take a break as this was wearing me out! I think I took the loop command out before I left for the day on Friday because I almost blew my email up. Please let me know what you see and what I can do to get this script to send to each person individually. Thank you! Candice
  8. CandiceCM

    Merge Letter Help

    I added loop to my script and it went crazy! Kept producing an email with all the recipients in one email over and over again. Had to force quit FM. Couldn't even force quit Mail. It kept launching the program over and over again. Crazy!
  9. CandiceCM

    Merge Letter Help

    Never used the Loop feature. I'll see if I can figure it out. Not even sure where that is but hopefully it is easy to find. Thank you do I add this loop script to my original script with my calculation of my letter?
  10. CandiceCM

    Merge Letter Help

    Hello Lee, can you help with my problem?
  11. CandiceCM

    Filemaker instant web publishing

    I had to change every single layout in my database to classic then design the layout manually. I was very disappointed to learn only after hours of work that the themed layouts do not work with IWP. I hope this gets resolved with an upgrade.
  12. CandiceCM

    Merge Letter Help

    I can get it to send the email to everyone in the "Email" category but is there a way to get to send to each person individually? I don't want to send the email addressed to 100s of people at a time.
  13. CandiceCM

    Merge Letter Help

    Okay, so now I have the letter as the body of my email but I can't get the contacts to automatically send to each specific email. I need to put this somewhere in my script right?
  14. CandiceCM

    Merge Letter Help

    Thank you so much. Going to take me awhile to get it right but this is the best way for me to learn.
  15. CandiceCM

    Merge Letter Help

    Thank you. So I was on the right track. Just seemed like a difficult way to do it. I got some of it to work. Here is what I wrote so far: "Dear " & Concrete Contractors::First & ¶ & "I understand you are involved with the " & Concrete Contractors::Project Name & "project. We would like to introduce our technology to you which provides 2x-4x the durability of typical Portland cement concrete at virtually the same cost. Additionally, if you have any secondary containment applications, we have materials that are extremely resistant to most chemicals without the need for coatings. I have included links to information for your review and if you would like to learn more about our technology and how we can decrease your maintenance costs and increase the lifespan of your concrete, please let me know. & ¶ & "http://www.ceratechinc.com/Content/PDFs/CERATECH-Industrial-Cement-Solutions-6.12.pdf & ¶ & "http://www.ceratechinc.com/Content/PDFs/KEMROK-BULK-Cement-Data-Sheet.pdf & ¶ & "http://www.ceratechinc.com/Content/PDFs/ekkomaxx-BULK-Cement-Data-Sheet.pdf & ¶ & "Sincerely, & ¶ & "Maja Gray & ¶ & "CeraTech, Inc. & ¶ & "1500 N. Beauregard St., Ste. 320 & ¶ & "Alexandria, VA 22311 & ¶ & "Tel: 703-894-1130 x24 & ¶ &" "Fax: 703-894-1068 & ¶ & I'm still getting errors with it. I know there are certain text items you can't use like "x" "/" and "-" etc. How can I make these items appear in my email? I really appreciate your help. I've spent hours on this.
×

Important Information

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