Hi,
Got this wonderful link online which allows me to email out based off certain criteria in the workbook by clicking on a link. However ive noticed when a part of the subject line (Cell B4 in this case) has more than two words it returns an error value.
Anyone got any ideas where I am going wrong here?
=HYPERLINK(CONCATENATE("mailto:"&K4,"?subject=","Reminder-",$B$1,B4,"&Body=","Dear ",J4,"%0D%0A %0D%0APlease send us ",B4," for the ",TEXT(E4,"dd/mm/yyyy"),"%0D%0A %0D%0AKind Regards,%0D%0AJoe Whitaker%0D%0A0412345678"),"Email this person now")
TIA
Got this wonderful link online which allows me to email out based off certain criteria in the workbook by clicking on a link. However ive noticed when a part of the subject line (Cell B4 in this case) has more than two words it returns an error value.
Anyone got any ideas where I am going wrong here?
=HYPERLINK(CONCATENATE("mailto:"&K4,"?subject=","Reminder-",$B$1,B4,"&Body=","Dear ",J4,"%0D%0A %0D%0APlease send us ",B4," for the ",TEXT(E4,"dd/mm/yyyy"),"%0D%0A %0D%0AKind Regards,%0D%0AJoe Whitaker%0D%0A0412345678"),"Email this person now")
TIA