CVarious code snippets

Email from Google sheets

Sending emails from Google sheets. Not tested with high number of emails

text2column

Transforms text in a single column in a table with multiple columns in vba

' Changes this -----> INTO -----> this ' ' Mickey Mouse Mickey Mouse Mainstreet USA Evening shift ' Mainstreet USA Donald Duck Frontierland Japan Breakfast ' Paris Daisy Duck ...etc.... ' evening shift
' ' Donald Duck ' Frontierland ' Japan ' Breakfast ' ' Daisy Duck ' ...etc... '