Hi.
I have created an Excel form that allows users to add up to 90-odd pieces of employee data including a picture of the employee and then send the information (as an attachment) to an email address via the commandbutton1.click event
At the other end, the receiver of the email saves the attachment and uses another workbook (containing all employee records) to open the email attachment and add the data to two of the worksheets: I put the text data into worksheet(1) and the image (if one is included) into worksheet(2) (for cosmetic reasons).
The text data is fine but the image data is causing me a lot of difficulty. I can get the image to save to worksheet(2) and add the name below etc but ideally I would like to add a textbox below each image to allow grouping of the two images for sorting purposes.
I have been researching and testing potential solutions for several hours now and I'm getting 'drained' so I am hoping someone out there has a solution that I am as yet unable to find. Any help would be greatly appreciated.
Cheers,
bja
I have created an Excel form that allows users to add up to 90-odd pieces of employee data including a picture of the employee and then send the information (as an attachment) to an email address via the commandbutton1.click event
At the other end, the receiver of the email saves the attachment and uses another workbook (containing all employee records) to open the email attachment and add the data to two of the worksheets: I put the text data into worksheet(1) and the image (if one is included) into worksheet(2) (for cosmetic reasons).
The text data is fine but the image data is causing me a lot of difficulty. I can get the image to save to worksheet(2) and add the name below etc but ideally I would like to add a textbox below each image to allow grouping of the two images for sorting purposes.
I have been researching and testing potential solutions for several hours now and I'm getting 'drained' so I am hoping someone out there has a solution that I am as yet unable to find. Any help would be greatly appreciated.
Cheers,
bja
