Create Excel sheet with VBA to open Outlook OFT and prepopulate with info from Excel sheet. Is this possible?

E

elitef

Board Regular
Joined
Feb 3, 2016
Messages
58
Hello
I want too know if its possible to have an excel sheet with a few fields that get prepopulated into the OFT template.

So I want A1 > D1 to be data that is inputted by me
Then press button to open Outlook oft file and prepopulate the fields from A1 > D1 in certain areas of the outlook email template
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

E
  • Question
Excel VBA to Outlook Email Draft - How to save email draft copy to sharepoint / How to use template from sharepoint?
Replies
0
Views
291
elitef
E
T
  • Question
VBA- Copy & Paste Range into Outlook as a Picture
Replies
1
Views
123
Domenic
D
L
  • Question
vba to send sheet as pdf in outlook with subject that is in a1
Replies
3
Views
219
Trevor G
Trevor G
J
  • Question
Parse HTML table or extract Outlook body items to excel sheet
Replies
2
Views
222
Jaffirahamed
J
B
  • Question
VBA to open outlook template a x number of times- getting run-time error '438' object doesn't support this property or method
Replies
1
Views
258
Norie
Norie

Forum statistics

Threads
1,215,034
Messages
6,122,782
Members
449,095
Latest member
m_smith_solihull

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