Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
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
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
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
Course of the Month10 days, 12 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.