Creating a Draft email Using Macro (For Thunderbird)

[edj777]

Hi!

I tried searching here on forum but I am unable to find the answer.

I have this columns: C2 and D2 always change value depending on the result of the other sheets.

[TABLE="******* 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]To:Email Address[/TD]
[TD]CC:Email Address[/TD]
[TD]Subject[/TD]
[TD]Message[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]abc@gmail.com[/TD]
[TD]def@gmail.com[/TD]
[TD]Reminder to send email[/TD]
[TD]Please send your email on ddmmyyy[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I want to do is to create a draft email populating the To, CC, Subject and the Message based on the information above using thunderbird. I saw VBA code but it only works for outlook. I really don't know how to do it for thunderbird.
Please help.
Thank you very much

 

[mole999]

Have you tried the Thunderbird forum, The outlook codes are specific to outlook

 

[edj777]

Hi
I did search but i cannot understand how to use the Function macro thing. the instruction is not enough for a novice like me. I was hoping that there will be an easier way to do it. Thanks anyway.