Hello everyone!

I have a feeling this should be a simple issue to fix - well I hope so anyway!

Basically I have a macro set up to save and send to a recipient and then CC to various other people which are determined with a vlookup in my spreadsheet.

When there is no requirement to CC someone, my formula returns a blank cell.

However, when using the macro, outlook interprets this blank cell as a 0 in the CC field.

Anyone know how to get around this please?

My code is set out like follows:

Range(“Q12”) & (“;”) & Range(“Q13) & (“;”) & Range(“Q14”)

Cell Q12 is always populated. Cells Q13 & Q14 will sometimes have one or the other populated or none at all. The 0 appears when neither are populated.

Some screenshots below of my formula and output - ignore the 0 in the To field - I was testing and didn’t populate this but it will always be populated usually so not an issue.

Thanks In advance

Tori