How can I use the Mailer within Excel from Nav

Business Central/NAV Developers Forum
1

I’m trying to open the e-mail function in excel from Navision I know how to open a new mail window with the excel attached but it’s not that i want. I want the mailer within the excel page. This is what i try to generate from Navision:

2

Hi Interesting question [:)]! You may check the EnvelopeVisible property from the workbook object. This works in Excel (tested): ActiveWorkbook.EnvelopeVisible = True This should work in Navision (not tested): YesNo := True; xlWorkbook.EnvelopeVisible(YesNo); bye André

3

Thx, it works but i have another problem now … How can put a mail adress / subject / attachment / … on the mail header. I tried to generate a macro but i get nothing.

4

Hi Please check the SendMail - method within the Excel - help. But then to show the mail header in Excel makes no sense (for me). I can’t find something regarding an attachment [:(]. bye André

5

I found “SendMail - method” help but not “SendMail - method within the Excel” help Anyway, i dunno how i can fill in the sendto and subject (and attachments) within excel mailer The sendmail method worked but it created a mail with the excel file as attachment. Any help with the Navision code would be great, thx in advance!

6

I really cannot find how to put the subject and sendto into the mail header. André, can you or some1 else please show me some code i can use in Navision to make this work? big big thx in advance!

7

Hi I guess this ist not possible (direct). But perhaps you can do this with a little work-around. Please check the following code first with Excel VBA. Application.Dialogs(xlDialogSendMail).Show "YourSendToAddress", "YourSubject" In this case the user can decide if he wants to send the mail or not (I assume this is what you want). If you think this could be the solution for your problem we have to translate the dialog into a number. Let me know if you need this. bye André

8

Did this: autApplication.Dialogs.Item(189).Show(‘test@test.com’,‘test’); If i do this i get the outlook window for new mail with the excel as attachment but i want the excel as text in the mail, not attached as a file. Thx for helping [:)] But still not what i’m looking for [:(]

9

OK. Then I can’t help you. Sorry. bye André

10

I don’t think this is possible. I tried to record the e-mail send process in a macro with VBA but no code was generated so i gues it is not supported then by excel automation.