I use a spreadsheet with a macro attached to import a text
file "file.*" the file is then formatted and sent to a
mail recipient via outlook. This works really cleanly, but
I now wish to make the mail recipient dependant on a value
held within the text file. My problem is that the text
file is opened from the sheet A063 the processing
completed and the file is then dumped. The cell with the
contact reference number is held in cell d21 on the active
sheet but the lookup is held on the sheet A063. Is it
possible to use a lookup to set a string contact name from
the same macro that formats the text file? If so how?
Any help appreciated.