Lartk
01-18-2013, 10:58 AM
The below code is used to fax:
Set oRecipient = .Recipients.Add("11111111@test.com")
oRecipient.Type = 1[
In cell E5 of the spreadsheet, it says Fax:111-111-1111
Is there a way to set the =.Recipients.add("SET THE FAX NUMBER TO REFERNCE CELL E5)?
But the only problem is in cell E5, before the fax number comes Fax:
So I would need to reference =RIGHT(E5,12). Is that possible?
Set oRecipient = .Recipients.Add("11111111@test.com")
oRecipient.Type = 1[
In cell E5 of the spreadsheet, it says Fax:111-111-1111
Is there a way to set the =.Recipients.add("SET THE FAX NUMBER TO REFERNCE CELL E5)?
But the only problem is in cell E5, before the fax number comes Fax:
So I would need to reference =RIGHT(E5,12). Is that possible?