As a relative newcomer - please forgive my often obvious questions.
I have now enabled my forms to output to excel-and then auto send to a recipitent of my choice(using a SendObject Macro)-the problem being i wish to email all forms from a given date to customers-preferably with only one click to the end user.
For example - a supplier has five deliveries running late on a Monday-i wish to press this button from the switchboard(or form) and be able to send details of those five vehicles and ETA's etc.
Im almost there- but the format of the outputted spreadsheet is awful-and i seem to be sending the whole table compacted into a spreadsheet too-as opposed to a single form/or a single date's worth.
Please help-i think\hope im starting to get there.