Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Popup Message

0

Most Respected Sir,

How to create popup message or message blinks in excel sheet on second recipient's computer, if the excel file emailed by the first recipient to second recipient.

Thanking you in advance.

Yours sincerely,

Barenya Sanyal

Answer
Discuss

Discussion

Hi Barenya Sanyal and welcome to the Forum.

Do you mean that a message is needed when the second recipient receives an email from the first (in Outlook)? 
John_Ru (rep: 6102) Feb 8, '23 at 11:27 am
Hello Barenya,

I too have a couple of questions.
Will it always be the same file or could it be any file that gets emailled?
Is the file password protected or not?
WillieD24 (rep: 537) Feb 8, '23 at 11:39 am
Plus, if the second person doesn't have Excel (and/or that file) open, is it okay to launch it?
John_Ru (rep: 6102) Feb 8, '23 at 1:58 pm
Most Respected Mr. John Sir.
Goodmorning; firstly thanks for your consideration. 
Regarding your query:
i) The desired Popup will appear only on second & subsequent recipient's computer.
ii) The mail system would be either Outlook or from Gmail.
With regards
Yours sincerely

Barenya Sanyal
ii) 
Barenyasanyal14 Feb 9, '23 at 12:13 am
Thanks but please reply to Willie's questions too.

I'm not sure this is a good idea. Outlook has a single project (unlike Excel) so you'd need to edit that in the second user's Outlook - that may not be allowed by their company's IT rules for example. 

If really want to do this, would you want the popup to be "live" (show when the email arrives)? If so, the email client must be running so why wouldn't the second person just use the email notification?
John_Ru (rep: 6102) Feb 9, '23 at 2:46 am
@Barenya
Just as John has suggested, using the "new email notification" would be the easiest (and best) way to alert the recipient to the email.

Then, after the recipient opens the file, the "pop-up message" would appear (on a worksheet) and all other sheets would be hidden until the user clicks a button (let's call it "OK") and then the messsage worksheet becomes hidden and all other worksheets become visible. The "message" worksheet can also have some code to give it "flashing effect".

Does this seem like a method you would like to have.

If you want to do it a different way, please provide as much detail as possible.

Cheers   :-)
WillieD24 (rep: 537) Feb 9, '23 at 1:07 pm
@Barenya

If you take up the kind offer implied by Willie's last paragraph, please remember that normally we don't allow users to specify mini-projects then cide them (so don't suggest a very extravagant solution!) 
John_Ru (rep: 6102) Feb 9, '23 at 1:13 pm
@Barenya

As John states, this forum is not for getting someone else to do the work. If you like the method I suggested you should watch the Teach Excel tutorial at the link below. 

Make Users Enable Macros

@John_Ru: after reading your comment I realized I was starting to "dig myself a hole" so I suggested the above. Barenya should be able to solve his issue by following Don's tutorial.

Cheers  :-)
WillieD24 (rep: 537) Feb 9, '23 at 3:41 pm
@Willie Unless I misunderstand Barenya, his question would require detecting email receipt in Outook and causing an alert in Excel (say a Message Box) so your suggested tutorial is a good start but not enough. Such a solution might take a couple of hours of coding /testing but implementation with recipients is likely to be problematic. Not sure about you but I don't know enough about Gmail to do it with that email client.
John_Ru (rep: 6102) Feb 9, '23 at 5:53 pm
@John_Ru: To have 'something happen' when a file is emailed is (currently) above my skill level so I wouldn't be attempting anything along that method. I also suspect that would get fairly complex. There would need to be something in the file to trigger the pop-up when the email lands in the recipient's inbox. It would need to check if the recipient has Excel on thier computer. Then check if Excel is open - if not, then open it. And more. That's why I opted for Don's tutorial. In Barenya's case, the message might be about enabling macros as well as whatever other info is needed.
Since we are having difficulty getting questions answered I am not going to persue this further.

Cheers   :-)
WillieD24 (rep: 537) Feb 9, '23 at 7:14 pm
@Willie Agreed. I'm doing no more on this (sorry Barenya). I've done some VBA in Outlook and think a solution is possible but I don't have the time. Nor do I see a good reason for think- email notifications seem adequate (especially if the Subject is written to give a good clue). 
John_Ru (rep: 6102) Feb 10, '23 at 3:31 am
Respected Sir,
Good Evening, I would like to clarify three aspects regarding my "Pop up" query;
i) When the file sent by 1st recipient to second or subsequent recipients or subsequent recipient sends by emails to any other recipient. So crux of the issue and main requirement is the 1st recipient will never know that the file will provide pop up message if he(1st recipient) sends the file to any other recipient by email. 
ii) It could be any file of my discretion; on which this operation is choosen.
iii) The file may or maynot be password protected.

Yours sincerely

Regards
Barenya Sanyal
Barenyasanyal14 Feb 13, '23 at 7:30 am
Sorry Barenya but neither Willie nor I have an interest in pursuing this idea.
John_Ru (rep: 6102) Feb 13, '23 at 8:13 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login