User-defined type not defined in VBA

[Jyggalag]

Hi all,

I am facing an issue with an email macro. Specifically, I used the one from this website:

VBA Send Email from Excel

VBA Code to Send Emails From Excel In VBA, to send emails from Excel, we can automatically automate our mailing feature to send emails to multiple users

www.wallstreetmojo.com

However, when I run the code, it says the following:

Can somebody please help me fix this issue?

Thank you!

Kind regards,
Jyggalag

 

[RoryA]

In the VB Editor, click Tools - References, locate the Microsoft Outlook reference and select it, then OK out of the dialog.

 

[Jyggalag]

In the VB Editor, click Tools - References, locate the Microsoft Outlook reference and select it, then OK out of the dialog.

You're a genius Rory!

Thank you so much! And apologies for what is probably a very silly question for you It works now!

 

[RoryA]

Glad we could help.

And they say the only silly question is the one you don't ask...

 

[Jyggalag]

Glad we could help.

And they say the only silly question is the one you don't ask...

I appreciate that!

Also, if I may ask one final question, in case you are good with VBA

I wrote & vbnewline to get some space inbetween my message when I email it,

However, when I send out the email it looks like this:

Do you maybe know why my vbnewline does not effectively separate my text in the email body?

Apologies for the additional question and thank you so much once again

 

[RoryA]

You used the HTMLBody property rather than Body. HTML ignores linefeeds (you need specific tags like br for that). It doesn't appear you are doing any formatting so I'd just use the Body property.

 

[Jyggalag]

You used the HTMLBody property rather than Body. HTML ignores linefeeds (you need specific tags like br for that). It doesn't appear you are doing any formatting so I'd just use the Body property.

Thank you!

It worked, but I am not able to write in bold with a line under like this now, so my former code looks like this now in the email:

Do you know of any alternative for <u><b> (underline and bold) when writing in Body rather than HTMLBody?

Thank you once again Rory!

 

[Jyggalag]

You used the HTMLBody property rather than Body. HTML ignores linefeeds (you need specific tags like br for that). It doesn't appear you are doing any formatting so I'd just use the Body property.

Figured it out!

Solution (and thanks once again for all your previous help Rory!): replace vbnewline with "<br>"