Hi,
You need to choose either
static newsletter and you can use macros - since you have the subscriber context available or, the
dynamic newsletter where you have it basically on the web page - but then the visitor is just a public user and you do not have the subscriber context to use the macros.
Or, you can create a custom functionality - the link to the live page from the e-mail will contain e.g. a querystring with the subscriber ID which you can read on the page and personalize the content. However, this requires customization.
Best regards,
Juraj Ondrus