MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 217|Reply: 5

Mail Merge from drop down

[Copy link]

1

Topics

3

Posts

13

Integral

Member

Rank: 2

Integral
13
Post on 1-24-2017 13:00:06 | All posts |Read mode
Hi All,
I hope you're well and enjoying 2017 so far. I have a query and wanted to see if this is possible.
On my main worksheet I have a table with a drop down menu with names in it. When a certain name is chosen the table is populated with information. Within this table there are a group of names which this certain table needs to be emailed to. Is this possible?
If the above answer is yes then is it also possible to get this done automatically for all the other names in the drop down menu, keeping in mind that the names and the details in the table will change and that table will have to be sent to the people listed in that table.
Currently it takes me a long time to do this manually so wanted to see if there was a way to automate this
Thanks in advance
Reply

Props Report

34

Topics

1969

Posts

4182

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4182
Post on 1-24-2017 15:21:24 | All posts



It sounds do-able, but without a workbook all we can offer is generalizations.
Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to
[color=] Manage Attachments
to open the upload window.
Reply Support Opposition

Props Report

34

Topics

1969

Posts

4182

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4182
Post on 1-26-2017 05:54:52 | All posts



It sounds do-able, but without a workbook all we can offer is generalizations.
Attach a sample workbook.  Make sure there is just enough data to demonstrate your need.  Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.  Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to
[color=] Manage Attachments
to open the upload window.











Reply Support Opposition

Props Report

1

Topics

3

Posts

13

Integral

Member

Rank: 2

Integral
13
 Author| Post on 1-26-2017 06:23:38 | All posts



Thanks for your response and I apologise for the delay in replying. I'm not well at the moment. If you can give me some time I'll get an example loaded.
Reply Support Opposition

Props Report

1

Topics

3

Posts

13

Integral

Member

Rank: 2

Integral
13
 Author| Post on 1-26-2017 11:17:50 | All posts



Thanks for your response and I apologise for the delay in replying. I'm not well at the moment. If you can give me some time I'll get an example loaded.




Reply Support Opposition

Props Report

34

Topics

1969

Posts

4182

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4182
Post on 1-26-2017 11:35:51 | All posts



That's OK, I have plenty else to keep me busy in the meantime . I'll standby on this frequency.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:20 , Processed in 0.382012 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!