Email form with pop up box function

G

Guest

I would like to email a document as an attachment but give the user the
ability to enter in a number that the email will be sent to. Our MS exchange
users are categorized by numbers. For example once the user has completed the
form I would like them to be able to press a button, a pop up box appear
where they enter the numbers then press OK and the email will be sent to that
user with the attachment. Thanks for any info!
 
T

Tom Ogilvy

ans = InputBox("Enter number of user")

Then feed that to the vba command that is working with a hard coded number,
substituting this variable

Activeworkbook.Sendfile Recipient:=ans, Subject:="ABC"

as an example.
 
G

Guest

When I use the code I get a runtime 438 error; object doesn't support this
property or method. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Email document with pop up box 1
make message box appear when cell is clicked? 1
POP up Box 2
Outlook Creating an Outlook form 2
Access Automatically Send a notification email once a record is added 0
Create Pop-Up quiz Window with yes no questions 0
Pop-up form that creates record that links 1:1 to main form 0
pop up during calculation 6

Top