Hi,
i have a code that prints a range as a jpg, opens outlook and puts it in.
What i need it to do is name itself as the filename to which it is created in.
Example:
c/data/excel/1234 myclient.xls ( file it is to be created in)
i would like it to name itself 1234 myclient.jpg

it doesnt save anywhere, only as an attachement but it needs a name. i can
alter the code and give it a standard name like Quote.jpg but when you send
alot to the same person and they save the attachment, they all have the same
name so this is why i need the change. Can this be acheived?

REgards,

Nigel