Outlook MailItem Object Adding Attachments Issue

[EdwardSnowden]

Hi,
I am creating a macro that creates a draft of an email in Outlook and pulls an attachment from a specific path. My code has been working, up until the point of adding attachments. The To, From, Cc, Bcc, subject, body, etc. all work but when adding in Attachments.Add I get the error message "Object required." If I simply use ".Add" I get the error message "Object doesn't support this property or method." Below is the snippet of code where the ".Attachments.Add" and ".Add" are failing. Any advice is highly appreciated :D

Please Login or Register  to view this content.

[bulina2k]

Hi there Edward,

If you put Debug.Print File_Source & "\" & Invoice_Num & ".pdf" just before .Add File_Source & "\" & Invoice_Num & ".pdf" what do you get in the Immediate window?

[EdwardSnowden]

Update:

The following code worked, however, the file isn't being attached. The name of the file is "123," not "123.pdf," so I removed the ".pdf" portion, and I've tried having the cell value for the Invoice_Num variable be both text and number formats. Invoice_Num is dimmed as a variant. Any help on this portion is highly appreciated.

Please Login or Register  to view this content.

[rorya]

It should be .Attachments.Add

[EdwardSnowden]

Sorry, I didn't refresh the page before submitting my reply. There is no error message after my code update, it just isn't adding the attachment.

[bulina2k]

try .Attachments.Add not just .attachments

[EdwardSnowden]

I tried this and it is saying "Cannot find this file. Verify the path and file name are correct." I don't know why it is doing this. I added in the msgbox method to show what it is searching for specifically and it shows the correct file path and file name. I double checked the properties of the file in windows explorer and the path is the same. The file name is also correct. Any ideas?

[rorya]

Are you sure the file doesn't have an extension? That's pretty unusual.

[EdwardSnowden]

I tried it with ".pdf" and without and it is saved as a pdf.

[bulina2k]

If you browse, using the windows explorer, to the location of the file (exactly as in File_Source) can you see the file there? Is your windows system set up to show the file extensions?

[EdwardSnowden]

I tried the browsing instructions you gave and it does bring me there.

I don't know exactly. I will say, when looking in that path, it just shows "123" as the pdf name. Is that what you mean?

[bulina2k]

Here: https://www.howtogeek.com/205086/beg...le-extensions/
This will allow you to set up windows to see file extensions, so you will be able to see the entire file name and path and compare it with the one in the code.

[bakerman2]

How do you get to the attachment being created ?

Share the code where you create the pdf-file. If you use ExportAsFixedFormat the extension is added automatically.

[EdwardSnowden]

I don't have code to create the PDF. Currently, the accounting department is manually creating the PDFs via word and saving them in that pathway. Am I understanding what you are asking correctly?

[EdwardSnowden]

I will read over that link to see the path shortly. Thank you for that :D

[rorya]

If you're using .Attachments.Add and the full file path with extension, and still getting a file not found error, then something has to be wrong with the path/name.

[nigelog]

How have you set File_Source ??

[EdwardSnowden]

rorya, thank you! I realized that after converting text to columns, the leading zero in the actual invoice number was removed and not matching (I used an imaginary invoice number in this thread as an example). Thank you!!!!

nigelog, I did set File_Source :D