I have the task of getting a section of our database to email to specific people a report created from a form. So far so good. The problem is that at present when the report is created it creates a one off report from all the forms completed rather than selecting the report from the current form. I am trying to relate to a macro from an older version of the database (2007) but what works in that one does not seem to work in this one. I am probably being really thick but this is still very new to me, (I only started programming in Access in September last year and only ever seem to get short periods of time to sort things out):banghead: