Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-10-2014, 02:43 AM
ASW122 ASW122 is offline Not press F9 to refresh URLs? Windows 7 64bit Not press F9 to refresh URLs? Office 2010 32bit
Novice
Not press F9 to refresh URLs?
 
Join Date: Jul 2014
Posts: 3
ASW122 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
It's not at al clear why you're using CSV files for the mailmerge, when the data are already in some other application (Excel?) that can most likely be used as the data source.

As for the URLs, unless you've gone to the extra steps to insert them as clickable links (see the 'Mailmerge TIPS' Sticky thread at the forum top), there shouldn't be any fields in the output to update. Are you sure the merge is being executed, rather than just previewed?
CSV because that's what our CRM database outputs. Its not actually a great system, mainly because no one who actually uses it regularly was involved in choosing it. We were going to get the upgraded version of our old system, but then one of the owners golf buddies recommended it, so it became the be-all-and-end-all (its actually a horrible system designed for a rental style business like car rentals rather than a stock sales based business with a load of mediocre stuff tacked onto the side of it, half of which is actually no use. I spend half my life making data analysis spreadsheets because it can't do it, but its all we've got to work with).

And again, because of the boss, it does have to be a clickable link. He's pretty OCD so the idea of having something like

https://www.ABCD.com/stuff/?f=123456...&salesman=Fred

in the email as text rather than a link saying "click here" would be unthinkable. He can't even tolerate us having a spare monitor, tower and cables in a cupboard in the back of the stores room so that we have a fall back if something breaks. The idea of something going to customers which wasn't all pristine and perfect would be criminal. And he's no more computer literate than his new marketing manager, in his eyes anything is doable, everything is straightforward and nothing will take longer than half an hour to do. If it does, its not down to the complexity of the system or an inherent limitation of the system, or even "Its processing 110,000 records of 50 columns to produce 70 different stats so its gonna take a little while to process". If its not done the way he wants in the time scale he wants, you're clearly not doing it right.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not press F9 to refresh URLs? Fetch images from URLs automatically claftchi Word VBA 1 12-25-2013 01:25 AM
How do MS Office products link to URLs? stegraham Office 2 10-22-2013 04:52 AM
Not press F9 to refresh URLs? URLs in citations acappella Word 3 07-24-2012 03:28 PM
mailmerge with custom URLs? guthrie Mail Merge 0 03-06-2011 08:39 PM
Sound Refresh aeroica PowerPoint 2 06-13-2009 01:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft