Jump to content
Sign in to follow this  
Jimbojames30

Export all records and email

Recommended Posts

Hi all,

new to filemaker but love learning it !!! i am building my first database which ultimatly i would like to go on an Ipad,

what am doing is scanning barcodes into a table, when im done i want to hit a button and it email that table as an attachment

In access i could create a macro called Send Object is there an equivalent in filemaker i dont want to save and then attach

i have seen the save to excel script but it asks to say it, i have attached a copy if this helps

many thanks in advance

Share this post


Link to post
Share on other sites

It would be very helpful to understand why you need this. You wouldn't email a table. You could email a report as a PDF, include a list of records in the body of the email or attach an excel worksheet. Please explain the workflow with more detail.

Share this post


Link to post
Share on other sites

It would be very helpful to understand why you need this. You wouldn't email a table. You could email a report as a PDF, include a list of records in the body of the email or attach an excel worksheet. Please explain the workflow with more detail.

Hi and thank you for taking the time to read my post, sorry I will try to explain better

I am scanning barcodes into a table , once I have scanned all the barcodes onto the table I need to email back all the data in an excel file

Reason for this is the barcode data needs to be processed via a 3rd party so it's just data collection I am after

Once an email h been sent I will delete all the records in that table and start again at a different place

Share this post


Link to post
Share on other sites

You can use the Export or Save as Excel commands to save your data to a file, which you can then attach to an email.

Share this post


Link to post
Share on other sites

You can use the Export or Save as Excel commands to save your data to a file, which you can then attach to an email.

Hi Fitch,

So there isnt a script which could profom this like in access,

CHeers

Share this post


Link to post
Share on other sites

Both the "export" script step as the "save as excel" script step have an option to generate an email with the exported file as an attachment. You'll see it when you specify an output file.

There is a separate "send mail" script step that you can use if you want more fine-grained control.

Share this post


Link to post
Share on other sites

Sorry for the confusion, when I said commands I should have said script steps. (Most commands are also available as script steps and v.versa.)

Share this post


Link to post
Share on other sites

  1. Thanks for all your feedback and comments, i have seen both scripts the Export & save as excel,

do you have to specify a path and not just click - create email with file attachment as i dont want to save just email the records as an attachment

just looked on filemaker go and in the settings i can go to export as email but i need this in a button (Script)

many thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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