Mailmerge From address have to be change for each email

S

satish78

Board Regular
Joined
Aug 31, 2014
Messages
218
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.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

I
  • Question Question
VBA Module to save & Send Active Sheet to List of recipients
Replies
1
Views
342
severynm
severynm
crook_101
  • Question Question
VBA to loop when sending email
Replies
1
Views
221
crook_101
crook_101
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
548
Amo840812
A
S
  • Solved
Tweak to VBA email code
Replies
3
Views
757
rollis13
rollis13
E
  • Question Question
Split Specific Sheets into New Excel Workbook and email to different people
2 3
Replies
23
Views
1K
Excel2021
E

Forum statistics

Threads
1,223,897
Messages
6,175,271
Members
452,628
Latest member
dd2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top