For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Outlook 2010 mail merge through VPN
Posted on 2011-03-11
I have a rather complicated question and I will try to make it understandable in English, which is not my native language.
I have a small company with an office and I also work from my home with a VPN connection to the Office Server running SBS 2003.
Up to now, I used Office 2003. For offers to customer and enquiries to suppliers, I have used Word dot files, linked to an Access 2003 database. Through Word 2003 I sent personalized e-mails with Outlook 2003 mail merge.
This worked in the office but also from my home through VPN. I simply opened the Word.dot file 9with the link to the database. With mail merge and Outlook I could send separate messages to either customers or suppliers.
I recently upgraded to Office 2010 on both locations and now this method is not working from my home anymore? I converted the Access database to the 2010 version. I also converted the Word.dot files to the Word.dotm files but I cannot send my messages anymore through Outlook 2010.
I have checked macro settings and other security setting because I assume it is related to security setting but I am not sure of course.
I use the Dutch language version of Outlook.
I have a small company with an office and I also work from my home with a VPN connection to the Office Server running SBS 2003.
Up to now, I used Office 2003. For offers to customer and enquiries to suppliers, I have used Word dot files, linked to an Access 2003 database. Through Word 2003 I sent personalized e-mails with Outlook 2003 mail merge.
This worked in the office but also from my home through VPN. I simply opened the Word.dot file 9with the link to the database. With mail merge and Outlook I could send separate messages to either customers or suppliers.
I recently upgraded to Office 2010 on both locations and now this method is not working from my home anymore? I converted the Access database to the 2010 version. I also converted the Word.dot files to the Word.dotm files but I cannot send my messages anymore through Outlook 2010.
I have checked macro settings and other security setting because I assume it is related to security setting but I am not sure of course.
I use the Dutch language version of Outlook.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
7 Comments
Hi,
What kind of VPN? SSL VPN?
Try to add the ip of you VPN site/server to "Trusted Sites" in Internet Explorer.
Try using the Outlook OWA. Does that work?
//zaZagor
What kind of VPN? SSL VPN?
Try to add the ip of you VPN site/server to "Trusted Sites" in Internet Explorer.
Try using the Outlook OWA. Does that work?
//zaZagor
Thanks for your reply. To be honest, I don't know what kind of VPN I have, just the standard VPN I guess. How can I see what kind of VPN I have?
I do not use Internet Explorer in this procedure so can it still make a difference if I add the IP to the trusted zone?
I have always assumed that Outlook OWA does not have all the functions I use for this and I must confess that I never actually tried it.
What I do is;
Open the VPN to the server in the office.
In file explorer, go the the Word.dot(x) file I need.
Open the dot(x) file so the link to the Access database is also activated (get some sql warnings but no big deal).
Now I have the Word file on the screen and through one the the tabs in Outlook I can select the recipients and send the e-mail with mail merge.
As said, I use the Dutch Outlook version so I don't know the English names of the functions and tabs I refer to.
I do not use Internet Explorer in this procedure so can it still make a difference if I add the IP to the trusted zone?
I have always assumed that Outlook OWA does not have all the functions I use for this and I must confess that I never actually tried it.
What I do is;
Open the VPN to the server in the office.
In file explorer, go the the Word.dot(x) file I need.
Open the dot(x) file so the link to the Access database is also activated (get some sql warnings but no big deal).
Now I have the Word file on the screen and through one the the tabs in Outlook I can select the recipients and send the e-mail with mail merge.
As said, I use the Dutch Outlook version so I don't know the English names of the functions and tabs I refer to.
When I use a plain text file, it takes a long time but the e-mail is sent. Meanwhile I assume it is ralated to Outlook 2010 not being the standard e-mail client.
I am running Windows 7 and I have put Windows Mail back from Vista to Windows 7 so perhaps this is causing the trouble I now have with Outlook 2010. I checked and Outlook 2010 is set as standard client. Just selected it again, just to be sure ;-).
In my other PC in the Office I have done the same thing with Windows Mail and there mailmerge works fine so perhaps I should re-install Office 2010 or remove Windows Mail. Maybe the sequence on my PC in the office was different but I can't remember that.
I am running Windows 7 and I have put Windows Mail back from Vista to Windows 7 so perhaps this is causing the trouble I now have with Outlook 2010. I checked and Outlook 2010 is set as standard client. Just selected it again, just to be sure ;-).
In my other PC in the Office I have done the same thing with Windows Mail and there mailmerge works fine so perhaps I should re-install Office 2010 or remove Windows Mail. Maybe the sequence on my PC in the office was different but I can't remember that.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Changing a few Outlook Options can help keep you organized!
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA).
For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651
If you want to manage em…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 11 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.