User-defined type not defined.

[estra]

Hi All,
New problem***
The attachments are not showing in the email. I think they're there then they disappear. In the old code, I only had .Body instead of HTMLBody because the signature wasn't there. Now it is with the HTMLBody, but not sure what's impacting the attachments.


---thisisfixed--- I basically copied an existing bulk email macro to a new workbook but it's giving me an error: User-defined type not defined. When I click on the definition, it says identifier under cursor is not recognized. Not sure what I am doing wrong. The macro works in the other workbook. I'm getting the raw data from another sheet (same workbook), then have formulas in the actual macro worksheet like concatenating the body. ---thisisfixed---

Please Login or Register  to view this content.

[Trebor76]

Hi estra,

Welcome to the forum!!

As the code is using early binding you need to make a reference to the desired object library (Outlook in this case).

To do this select the Microsoft Outlook [N.N] Object Library option from the list of Available References found from Tools > References menu within the macro editor where N.N is the version number (mine currently is 15.0).

Regards,

Robert

[estra]

Hi estra,

Welcome to the forum!!

As the code is using early binding you need to make a reference to the desired object library (Outlook in this case).

To do this select the Microsoft Outlook [N.N] Object Library option from the list of Available References found from Tools > References menu within the macro editor where N.N is the version number (mine currently is 15.0).

Regards,

Robert

Thank you Robert!

That definitely fixed the error on the sub part. New problem though, the attachments are not showing in the email. I think they're there then they disappear. In the old code, I only had .Body instead of HTMLBody because the signature wasn't there. Now it is with the HTMLBody, but not sure what's impacting the attachments.

[Trebor76]

Hi estra,

You need to start a new thread for each new issue.

Thanks,

Robert