Mailmerge From address have to be change for each email

[satish78]

Hi Friends,

Is it possible to create drafts/ Marked as sent emails without sending emails using VBA.

I have list of emails in excel sheet in ColumnA, Where I want to create draft emails "From emails" picking from excel sheet to "From Address field"

Does not matter any text in subject line, body, no attachments in this task.
Let me if it possible.