SOLVED

attaching a file and sending it with attachments

%3CLINGO-SUB%20id%3D%22lingo-sub-3181630%22%20slang%3D%22en-US%22%3Eattaching%20a%20file%20and%20sending%20it%20with%20attachments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3181630%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20I'm%20new%20here%20but%20not%20new%20to%20Excel%20-although%20now%20I%20have%20to%20admit%20I've%20been%20a%20pretty%20basic%20user%20of%20Excel%20for%20about%2015%20years.%20I%20have%20to%20do%20something%20more%20advanced%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20list%20of%20people%2C%20data%20including%20emails%20phone%20numbers%20etc...%20on%20the%20sheet%20-and%20then%20I%20have%20to%20add%20a%20file%20to%20that%20row%20-%20one%20that%20includes%20a%20resume.%20Not%20a%20link%2C%20but%20the%20actual%20resume%20-which%20is%20usually%20in%20Word%20or%20PDF%20format.%26nbsp%3B%3C%2FP%3E%3CP%3EIN%20ADDITION%20I%20have%20to%20send%20this%20sheet%20to%20colleagues%20and%20not%20lose%20the%20files%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3181630%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3182912%22%20slang%3D%22en-US%22%3ERe%3A%20attaching%20a%20file%20and%20sending%20it%20with%20attachments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3182912%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310797%22%20target%3D%22_blank%22%3E%40Elena99%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20include%20the%20file%20using%20the%20menu%20%22Insert%20%7C%20Object%22%20(it's%20a%20very%20small%20icon%20at%20the%20far%20right%20of%20the%20menue%20bar)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_0-1645173149835.png%22%20style%3D%22width%3A%20739px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349429i60A928BE5208C313%2Fimage-dimensions%2F739x274%3Fv%3Dv2%22%20width%3D%22739%22%20height%3D%22274%22%20role%3D%22button%22%20title%3D%22DTE_0-1645173149835.png%22%20alt%3D%22DTE_0-1645173149835.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20the%20Object%20window%2C%20first%20open%20the%20%22Create%20from%20File%22%20tab%2C%3C%2FP%3E%3CP%3EBrowse%20for%20your%20file%3C%2FP%3E%3CP%3ETick%20the%20checkbox%20%22Display%20as%20icon%22%2C%20the%20other%20checkbox%20%22Link%20to%20file%22%20must%20not%20be%20ticked.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DTE_1-1645173304659.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349433iB322C3336FAEF85C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DTE_1-1645173304659.png%22%20alt%3D%22DTE_1-1645173304659.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20save%20the%20Excel%20workbook%2C%20it%20will%20include%20the%20inserted%20file.%20So%20you%20can%20send%20the%20workbook%20by%20E-Mail%20and%20it%20will%20still%20have%20the%20file%20included.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

HI I'm new here but not new to Excel -although now I have to admit I've been a pretty basic user of Excel for about 15 years. I have to do something more advanced now.

 

I need to create a list of people, data including emails phone numbers etc... on the sheet -and then I have to add a file to that row - one that includes a resume. Not a link, but the actual resume -which is usually in Word or PDF format. 

IN ADDITION I have to send this sheet to colleagues and not lose the files attached.

 

How do I do this please?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Elena99 

 

you can include the file using the menu "Insert | Object" (it's a very small icon at the far right of the menue bar)

DTE_0-1645173149835.png

In the Object window, first open the "Create from File" tab,

Browse for your file

Tick the checkbox "Display as icon", the other checkbox "Link to file" must not be ticked.

DTE_1-1645173304659.png

 

 

When you save the Excel workbook, it will include the inserted file. So you can send the workbook by E-Mail and it will still have the file included.

@Martin_Weiss thank you so much -this worked!