New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

using drop down menu - but sending as email

Macros, VBA, Excel Automation, etc.

using drop down menu - but sending as email

Postby terrigregory » Wed Jan 25, 2012 11:02 am

I am working on a project, that requires drop down menu in excel spread sheet. I am using excel and outlook 2007.

The worksheet has several columns that have to be free filled by the person receiving the email, then one column is a a drop down menu of choices to control the answers. - Ideally i would like to copy/paste or embedd this data into an email, be able to email and the recipeient get the email and be able to input info in blank boxes AND choose from the drop down menu in the one column...is there a way to set this up?

ex. position
coumn a column b
name

they enter would be a drop down box with 6 different choices...
  • 0

terrigregory
Rookie
 
Posts: 1
Joined: Jan 25, 2012
Reputation: 0

Re: using drop down menu - but sending as email

Postby charles » Wed Jan 25, 2012 1:29 pm

Hi,

Welcome to the forum. It would helps us better understand your situation if you could provide a copy of the workbook.
  • 0

There are other ways too do this but...

Be kind let us know if you posted somewhere else!



Charles
charles
Excel Badass
 
Posts: 632
Joined: Dec 10, 2011
Location: Mississippi
Reputation: 1
Excel Version: Excel 2003, 2007 and Mac 2011

Re: using drop down menu - but sending as email

Postby Sisyphus » Wed Jan 25, 2012 8:35 pm

Hi,
By nature, Outlook is more closely related to Word than to Excel. There are also ways to create forms in Outlook itself. But, truth be told, if you were to agree with me, I still wouldn't be able to help you. :oops:

:idea: Perhaps your question be better asked on an Outlook forum.
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google Adsense [Bot] and 144 guests