Search results for query: *

Hi I've set up an email signature for clients with images (jpg)and mail format as HTML. In Outlook 2002 it works fine but on upgrading to 2003 the images appear in the body of the email message (good) but also as attachments by the recipients. Any ideas? I'm tearing my hair out over this as it...

Click on the mail merge field in the Word doc with the right mouse button and select Toggle Field codes, then edit it to read: {MERGEFIELD "YourDate"\@ "MMMM dd, yyyy" \* MERGEFORMAT} Then toggle again. Don't know how you get the comma before the year, though it doesn't show on mine. HTH

That definitely sounds like it is your query that is causing the problem, how is it set up, ie tables, links, etc?

Hi 74Stag This is how I have it set up in my db: When user has the form open and wants to produce the letter for the record showing in the form, they click a command button which has this code as the Event Procedure for the OnClick event: Private Sub CmdButton_Click() DoCmd.RunCommand...

Insert your section break at the end of your second to last page Go to View, Header and Footers in the new section. Go to wherever the page number is showing on the previous page and untick the button on the H&F toolbar that says Same as Previous. You can then remove the page number from that...

Put a section break in your document just before the last page and set the header/footer for that section only to have no page number. Section break is from Insert menu, Break, Section break next page Hope that helps

Which program? Word & Excel file locations are settings in the Tools, Options

Which version of Word and Access are you using? How are you trying to link to the Access query from Word? I've just tried it with 2002 (XP) and it works fine but you need to remove the criteria from your query, then set up the mail merge template in Word linking to the query then put the...

Hi It sounds like there could be something wrong with your criteria in the query. I do the same thing (I think), ie when a user clicks a button the code runs a query with the form criteria and outputs a document based on a template in Word. This is my code if it helps: ' set the path to the...

Try posting in the Microsoft Access forums in this site, lots of expertise there.

Will your users be running the mail merge from Access or from Word? If from Access then you could create a query with a parameter prompt for them to select the criteria they want then Tools, OfficeLinks, Merge it with MS Word. If they are started within Word then you can use the Mail Merge...

I did something similar in Word 2002, whereby I created a table then clicked on Table AutoFormat, chose a format vaguely like the one I wanted, then clicked Modify, changed the settings to suit my format and clicked Add to Template. It then created a table style which I could apply at will. Hope...

Thanks again. I found out that by placing the images in front of text in Word as opposed to in line with text, they showed properly in the email stationary and it now works fine.

Thanks for your reply. Can you please tell me how I link the Word template to Outlook? I've tried going through the stationary picker in Mail Format options but it is only allowing HTML files. If I save as HTML the same problem occurs with the red cross placeholders. Thanks. Moira

Hi I hope someone can help me, I've searched the tektips site and found some useful stuff on creating email stationary in Outlook but not my specific requirement, which is for company logos down the right hand side of the message with the message typed on the left. I have tried setting this up...

Thank you to chiragd for the reply which I have just used to solve this problem at a client's site. Just goes to show that searching this site pays off.

Hi Does anyone know if it is possible to send email with a pop up message for example: Please confirm if you have read and understood this content YES NO (the receiver clicks the relevant button) And the sender receives the answer by email. Always grateful for any help Moira

Thanks for your reply. I should have made it clear that the cell in question is a combination of text and numbers like this: XX1, XX2, XX3, then the number at the end increases by one for each cell in the Autofill without holding down Ctrl.

Hi One of my clients has found that using Excel Autofill to fill down a column incrementing by one for each row only works if she holds down the Alt key while doing the fill down. Otherwise it only copies the cell contents. On my PC the same feature works fine with the same spreadsheet. Any...

Yeah the default style cannot be deleted nor can Normal or heading styles. But any styles developed by the user can be deleted. If you have a set of standard styles, say in your Normal template, or in another document you can use the Organizer to copy these into your "fluffy" document which will...