Topics Search

Mail Merge: Clickable Hyperlink

Mail Merge: Clickable Hyperlink
Views: 20
I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named VideoLink1 and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this:

{ HYPERLINK { MERGEFIELD "VideoLink1" } }

Then merge new document, I am able to see its shown as a hyperlink ie. blue font BUT when the pointer hovers over it, the javascript note as it should says CTRL + Click to follow link and I do that, ctrl and click but the link does not open. Just to make it clear the my links are correct.
Sponsored Links:

More topics

 

Mail Merge: Clickable Hyperlink

Preview
I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named VideoLink1 and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this:

{ HYPERLINK { MERGEFIELD "VideoLink1" } }

Then merge new document, I am able to see its shown as a hyperlink ie. blue font BUT when the pointer hovers over it, the javascript note as it should says CTRL + Click to follow link and I do that, ctrl and click but the link does not open. Just to make it clear the my links are correct, here is one of them, you can see its:

http://www.youtube.com/watch?v=51gBN4nA9s
 

Hyperlink email won't mail-merge

Preview
I have recently changed my email field in access 2010 to a hyperlink. However, now when I go to mail-merge in Word 2010 it won't send because its not reading the email address correctly
 

Mail Merge macro

Preview
so I have made a mail merge for my database and it works fine and im happy with it. Now I just need to create a macro so I can create a button on my switch board which allows me to access the mail merge and the send it to the recipitent automatially. The mail merge is formed by a query
 

Open on specific record in mail merge

Preview
I've just created a button that uses the RunApp macro to open up a mail merge for our database. Is it possbile through some VBA code to jump to an exact record in the mail merge? So, for example, if I'm on AccountNumber 29 and click the Mail Merge button, the mail merge will open up on AccountNumber 29. Is this possible at all
 

Making text a hyperlink

Preview
What I have is a form in Access that has a command button on it that when clicked it opens a new outlook mail message with text already inserted into it. Part of the text is:

Please visit the Facilities Operations page for more information.

How could I possibly go about making the words " Facilities Operations " a clickable hyperlink in the the mail message?
 

"Clickable" title in report

Preview
In a Report, is there any way to embed a hyperlink within a text box that is pulling data from a field other than the field that a hyperlink is stored in? For example, my current report hasa textbox (txtTitle), and then beneath it another textbox that displays a clickable hyperlink, so the Report ends up looking like:
 

Form Field open Default mail client

Preview
Access 2003

I have a field on my database that is for email address.

When I display that field on a form I would like it to be a Mailto: link and open up the users default mail client (assuming they use a local client and not web based email).

The field is self in the table is set to "hyperlink"

Is this form by form coding (In other words can I have it clickable on some forms and not on others?). I guess I could just lock the field on the forms I do not want it clickable
 

Odd behaviour in email mailmerge from Word

Preview
I have an an Access database which allows the user to select data to be available for mail merging via Word 2007. It selects the required data into a temporary table which word connects to via an ODBC connection.

This works fine for standard mail merge (letters, envelopes, labels) I have been asked by the charity I created it for to also use it for mailmerging into emails. The data in the temporary table contains an email address (as a hyperlink) and when that hyperlink is clicked it opens up the default client as expected.

In the mail merge process, at the end stage when the emails are sent to Outlook it fails because what is sent as the address is (for an actual address of [LINK]) [@email]#mailto:[@email]# which Outlook does not recognise. Iwould have expected the address sent only to be like mailto:[@email]#
 

Mail merge for filtered results

Preview
This is the first time I am trying to do mail merge from access.

Actually I have a query and I have designed the letter template in Ms word.
Now I want to filter the query based on the data passed from the access form and merge the filtered data in Ms words mail merge
 

query being used to make mail merge list

Preview
I plan on doing a mail merge which will include the case id(s) from the data collected with this query. There are clients who have more than one case id but I only want to send them one letter that lists both cases and I’m not sure how to do that.

Is it something I do within this query, another query or the mail merge document itself.