how to save linked pictures into workbook as embedded pictures

I have an workbook with pictures that are linked to external picture files, and they are placed in the workbook via macro. When I email the file to another computer and open it, the pics do not display and show an error:

The linked image cannot be displayed. The file may have been moved, renamed, or deleted, Verify that the link points to the correct file and location.


I would like to be able to save the workbook with the pictures in them (without having to archive them) so that I can open it and see them on another machine.

Thanks!