Referencing Excel spreadsheet via Outlook?

P

phonesdontfly

New Member
Joined
Mar 2, 2016
Messages
16
Hello,

I would like to have a Userform in Outlook that I can call up to insert a unique identifier (eg. A barcode) and have it reference a specific excel file, and display some finite pieces of data based on that excel file reference (eg. Country, product, shipping condition, etc). How can this be done? I'm loosely familiar with VBA, just need a step in the right direction. Thanks
 
Last edited:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

R
  • Question Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
1K
rafeek4u
R
MCLIFTO8
  • Question Question
Article / Guide feedback requested. The best way to learn Excel.
Replies
0
Views
2K
MCLIFTO8
MCLIFTO8
H
  • Question Question
How can I break this 'Do While' loop up and add logic to copy specific tables from a user-selected spreadsheet?
Replies
3
Views
1K
Macropod
Macropod
Akuini
  • Question Question
I created an Excel add-in called “Search deList”, to create searchable data validation
16 17 18
Replies
170
Views
34K
Akuini
Akuini
L
  • Question Question
Trying to Copy and Paste Excel Range to Outlook but Paste Not Working
Replies
1
Views
905
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,224,819
Messages
6,181,153
Members
453,021
Latest member
Justyna P

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