Here you can see how I've mapped and automated the cutoff and resonance for my X-Station:
Important to note is that, because the macros aren't actually mapped to anything, they don't appear in the macro mapping window:
Don't let this throw you off: the macros are indeed receiving and transmitting MIDI, they simply aren't controlling anything within Live. Try adjusting a macro knob in Live: you should see/hear the change reflected on the synth.
But what if your synth receives CC data but doesn't transmit it? In this case you'd need some sort of intermediary hardware or software sitting between Live and the synth. Essentially, something that can send control changes to Live and allow MIDI messages sent from Live to pass through to the synth. I'm not going to explore this as part of this post as it's quite the complex solution, but technically speaking it's feasible with the right hardware or software.
Max for Live
The other, more elegant, solution is to create a custom UI for your synth in Max for Live--essentially rigging up virtual knobs and faders and mapping them to CCs. This is not for the faint of heart, however, as Max does has a fairly steep learning curve.
At a high level here's what the process looks like:
add an appropriate control for each parameter you'd like to automate (knob, fader, button etc.)
use the ctlout object to wire up CC control changes. Alternatively you can use pack alongside midi midiformat and midiout. The benefit of using pack is that you can "bang" it to force it to send its value--useful for a crude form of "total recall"
it greatly helps to use the "Presentation" layout to separate your wiring from your presentation
if you are controlling many parameters I would suggest embedding the low-level MIDI wiring into a sub-patch
Here you can see the two approaches side by side, controlling CCs 74 and 75 respectively. You can also see a send object that remotely bangs the pack.
Some synths, such as my Roland JX-10, only support SysEx for remote control. Unfortunately this is a shortcoming of Live: no SysEx support.
Luckily there is a tool called Bome's MIDI translator (Mac and PC) that can convert CC data to SysEx. The free version requires a 1:1 mapping (1 CC to 1 SysEx message) which can be quite cumbersome, but the paid version allows you to create expressions (say, CC X maps to SysEx X)
I won't go into detail on the specifics of how this is done, but suffice to say it is indeed doable. Here you can see the work of a frugal and obsessive individual:
(contact me if you'd like to chat about my Max for Live/Bome's JX-10 editor--I don't feel it's quite ready to share with the world but I would be happy to review privately)
Using Chains and automation to switch keyboard setups