Display and select email account for bulk emails

**Frankie_The_Flyer** · 11-11-2019, 02:27 AM

Hi
I have a code in a workbook that will be used by many different people with different email addresses to send bulk emails out. Currently the emails go out from the senders "primary" address.

Some users will have more than one sender address and will want to use their secondary (or more) address as the "From" address.

I have a code that counts the number of addresses a user which I've managed to get to bring up an input box, but for some reason the response doesn't display in cell L1 as it's meant to.

Is it possible to display all the senders addresses in a pop-up box so they can select one and the Code will send the bulk emails from that address?

Code so far:

Please Login or Register  to view this content.

Thanks

Frankie

**Keebellah** · 11-11-2019, 03:23 AM

Hi Frankie, you should place the list of accounts in a userform listbox or combobox so that the user selects the one he/she wants to use.
And to avoid unnecessary userform opening isf the user only has one account just skip the userform.
Hope my explanation makes sense
Take a look here (one of the hits with Google): https://social.msdn.microsoft.com/Fo...rum=outlookdev

**bakerman2** · 11-11-2019, 05:06 AM

Let's try this one to start with.

If more than 1 account userform pops up with addresses to select from.

Otherwise primary address is set in range("L1").

**Keebellah** · 11-11-2019, 05:13 AM

Nice one @bakerman2, works like a charm

**Frankie_The_Flyer** · 11-11-2019, 05:31 AM

Thanks Keebellah. The main issue is that I don't know the addresses of all the people that may use the worksheet so the code needs o find and display any addresses a random user may have. I'll have a go with bakerman2s solution tomorrow when I'm at the computer rather than the iPad. (Not quite as easy on the ipad🤣&#129315

**Keebellah** · 11-11-2019, 06:42 AM

Bakerma2's solution is the same as I implied, the only think you need to do now is edit the code so that it also reads the contacts of that particular user if you need to select the email addresses.
At least that is what I can make out of your question and explanation.
I didn't do anything, the work and credit is all for Bakerman2

**Frankie_The_Flyer** · 11-12-2019, 02:44 AM

Bakerman2 work acknowledged. Still appreciate your input though.

Frankie

**Keebellah** · 11-12-2019, 03:06 AM

Frankie, the code BAkerman2 has sent you does just that, the list of accounts IS the list that is for the user that is using the file.

**bakerman2** · 11-12-2019, 04:54 AM

Youre welcome and thanks for rep:.

PS: Frankie, that's what this forum is all about, Joint Ventures.

Display and select email account for bulk emails

LinkBack

Thread Tools

Rate This Thread

Display

Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Re: Display and select email account for bulk emails

Thread Information

Users Browsing this Thread

Similar Threads

Auto-select correct sending account when replying to a forwarded email?

[SOLVED] Send Bulk Emails

Attachments when sending bulk emails

Bulk emails with individual attachments.

[SOLVED] Bulk emails send use outlook & excel coding macro

[SOLVED]select random emails to display only on blank cells[YAY]

[SOLVED] how do I hyperlink 9000 emails in an excel file, for bulk emailin

Bookmarks

Bookmarks

Posting Permissions