I need some help.... i have created a simple email hyperlink, however when i click the HYPERLINK i need it to contain the contents of a cell A2 before the domain address. e.g 7752576311@domain.com
A2 needs to be changeable so that any info can be recorded there.
is there a command i could use?
[TABLE="class: grid, width: 5, align: center"]
<TBODY>[TR]
[TD]111111111[/TD]
[TD]7752576311[/TD]
[TD]0000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]222222222[/TD]
[TD]HYPERLINK[/TD]
[TD]0000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
A2 needs to be changeable so that any info can be recorded there.
is there a command i could use?
[TABLE="class: grid, width: 5, align: center"]
<TBODY>[TR]
[TD]111111111[/TD]
[TD]7752576311[/TD]
[TD]0000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]222222222[/TD]
[TD]HYPERLINK[/TD]
[TD]0000000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]