ExcelBanter - Macro Help Needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro Help Needed (https://www.excelbanter.com/excel-discussion-misc-queries/261385-macro-help-needed.html)

Dan Wood

Macro Help Needed

I have a macro to send emails which used to work but now doesn't. Whilst
running it within VB it flags an error with this part:-

'Execute the URL (start the email client)
ShellExecute 0 &, vbNullString, URL, vbNullString, vbNullString,
vbNormalFocus

I can't work out why because as far as i can tell nothing has changed.

All times are GMT +1. The time now is 08:58 AM.