search

Elmetayer / VBA-outlook-export

VBA executed in Outlook for exporting email details in csv format
0 stars 0 forks source link

Compile Error: User-defined type not defined #1

Closed cyril23 closed 4 years ago

cyril23 commented 4 years ago

When executing your script within Microsoft Outlook Professional Plus 2019, it shows the following message:

image (English: Compile Error: User-defined type not defined)

image

The problem occurs around Function cleanupEmailAddress(text As String) As String

I already tried adding some libraries I googled to be helpful in some cases, without success: image

Elmetayer commented 4 years ago

The macro is using RegExp, so you have to enable "Microsoft VBScript Regular Expressions" in the list of references. In the VBA editor, go to the menu Tools, then References, then select "Microsoft VBScript Regular Expressions x.x" where x.x is the current version on your system (e.g. 5.5)

Tell me if this solves your issue !

cyril23 commented 4 years ago

thanks! that solved it. great tool by the way! I needed it because Outlook doesn't export the date column in CSV.