Recent content by fusion786

Hi Peter The heading and the centre appear on each page rather than only at the beginning of the report. But I will try and insert section breaks at the end of each report. Thanks for your on-going suggestions. If you think of anything else please let me know. Regards

Hi dr486 Thanks for that. The one problem that I have is that not all recipients will be sent the same attachments. All recipients will get different reports so I need a way of linking the reports folder (I was thinking of setting a folder for each recipient that will be sent an email will...

Hi Peter Thanks for that. I may have to go down the route you suggest to insert section breaks as I am struggling to do it they way I intended to. I have some coding that will search for each change in the file but it looks for a change in heading but all the headings in my reports are the...

Hi Paul Thanks for that. I am interesting in what you are suggesting. The other 2 reports that I need to send out with the report that will be as a word document are produced in a report writer software. I am able to save these 2 reports as a .pdf file but I am trying to figure out how to...

Hi. I have created a new thread with my question. The thread is thread68-667786 I have been suggested a coding which enables to split the reports but they split at each page rather than at the beginning of each report as some reports go over a few pages. An explanation and the coding can be...

Hi Paul Thanks for that. The email addresses are stored on a global contact list (the pcs are networked) but if necessary the required contacts can be set up on the pc that would be used for the reports. The reason why I may not be able to name the sub folders as first and last names is...

Hi Peter I tried inserting section breaks at the end of each report but this is very time consuming as there are abut 200 reports. Then each report would need to be saved manually. The first suggestion works fine except that the report splits at each page and the filename it uses to save is...

Hi Paul No I am running this from a pc using windows 2000. Basically to explain the process, in total I have about 200 x 3 reports that are currently printed and sent out to the various recipients on a monthly basis. The idea is to cut out the flow of paperwork. What I am proposing to do is...

Hi I would like some help please with setting up a way of being able to email files (attachments) to various recipients at the same time automatically. All the recipients will get different files so I will need to assign a folder that will hold the files for each recipient to a email address...

Hi Peter Thanks for that! Suggestion 1 works better for me as it saves the files automatically though I need to work out how to get the files to save by report name rather than page10, page11, etc. The problem with this method is that it does not keep the page layout format exactly as the...

One thing I forgot to mention was that I would like if possible to have the output files saved in pdf format but is not essential if it is difficult to do.

Hi Thanks Frederico Enjoy your holiday. If I can have help with the coding to be able to split the documents that would be great. Saving the output into pdf is an ideal situation but not essential at this stage. I will have a look at pdffactory. Being able to automatically split the...

Hi. I have a similar situation. I have got one word file that contains many mini reports. What I need to be able to do is to split the file into the various reports. At the beginning of each report there is an identifier to indicate a new report: center 1234, center 2100, etc. Each report has...

Hi. I have one big word file that contains many mini reports. What I need to be able to do is split that file into the various reports and files. I can not do this manually as there are hundreds of reports on this file. There is a common field that identifies a change in report. There is a...

Hi. I have two tables, [invoice details] and [supplier details]. the supplier details table contains 2 fields, supplier code and supplier name. The invoice details contains many fields including supplier code and supplier name fields. I use a form based on the invoice details table. I have...